Skip to Content
0
May 10, 2018 at 12:34 PM

SAP IDM8.0- not able to assign DB privilege

129 Views

Dears,

I have connected Non-SAP repository (Oracle DB) & defined all required parameters.

I am creating manual privilege (with DB repository assigned to it) from IDM8 UI and then assigning it to user from UI. But no jobs are triggered after assignment. Below are some more details about configuration..

1. I have similar working setup in IDM7.2 and trying to implement in SAP IDM8.0

2. The processes (task) are similar to IDM7.2 and i have done required changes in scripts/parameter values.

3. I can see that newly created privilege is available in IDS DB but not getting updated in destination DB.

3. the below query should get executed after priv. assignment

INSERT INTO NES_SAPIDMUSER (SAP_USERID,SAPIDM_GROUP_NAME) VALUES ('%MSKEYVALUE%','$FUNCTION.GetPrivilegeMSKEYVALUEclean(%MXREF_MX_ROLE%)$$')

I am not getting any logs, kindly help, where to check detailed logs ??

Attachments

repconstants.jpg (81.6 kB)
event-process.jpg (121.7 kB)
passes.jpg (150.2 kB)