cancel
Showing results for 
Search instead for 
Did you mean: 

SAP IDM help

Former Member
0 Kudos

Dear experts,

As beginner, I am trying to understand from which tables/iViews the data in the IDM UI comes from.

I trying to display the user assignments content but I am quite confused:

Question1: which sql request can provide this content for my user (screen A)? My question is focused on the "Assignments" not on the Assigned Privilges or automatic privilges.

When I click on the status "OK" I can read Direct/Inherited assignment.

Question2: How can I read this Assignment correctly? where is this data being stored (screen B)?

Thanks,

Mia

Accepted Solutions (1)

Accepted Solutions (1)

terovirta
Active Contributor
0 Kudos

Try searching from view idmv_link_ext.

  1. column mcThisMSKEYVALUE would be the unique id of an user
  2. column mcOtherMSKEYVALUE would be the unique id of the assigned access right
  3. columns mcLinkType and mcAssignedDirect would tell whether it's directly linked or inherited (privilege that's inherited via assigned role)

regards, Tero

Answers (0)