Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to find the status of the Role/privilege status form the database tables in idm 7.2

Hello Experts,

I would like to get the role/ privilege assignment status for the user like (ok/failed/rejected).

What is the attribute name and from which table/view we can get this status from. I am looking into the views but unable to get it.

Can someone kindly help me up.





you'll find the statuses in the link-table mxi_link where the mcThisMSKEY points to the user (MSKEY reference between mx_person to mx_privilege/mx_role) and mcOtherMSKEY points to the linked object.

To find the user or role names you need to join the link-table's columns mcThisMSKEY or mcOtherMSKEY to the view containing active entries idmv_entry_simple (column mcMSKEY in that view).

The interesting columns are mcLinkState, mcExecState and mcExecStateHierarchy.

As Pradeep today pointed, the status codes are documented in: LinkExecState and LinkExecStateHier

The view idmv_link_ext is easier to work with as it has mcThisMSKEYVALUE/mcOtherMSKEYVALUE columns displaying the unique names of linked objects but it seems to show only active and pending assignments (not removed assignments).

regrards, Tero

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question