on 02-05-2015 3:26 PM
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.
Regards,
Dev
Hello,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.