Skip to Content

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

Finding Role & Role Approver info in IDM 7.2

Hi Team,

Can any one kindly provide me the View/Tabe name/SQL Query that provides the list of roles by approver or vice versa?

I could able to find the info for role name & owner but not approver info.


Venkata Bavirisetty

Former Member
Former Member replied

Ok, I answered a different question noone had asked then.

I would usually have put the approver(s) in the role's MX_APPROVERS attribute, so thats where I'd look, or better yet, the approvers are in a role that is stored in the MX_APPROVERS attribute so when I remove the person from the approver role it sorts itself out.

This should list roles/privileges where ADMINISTRATOR is an approver:

select mcmskey,mcmskeyvalue,mcDisplayName from idmv_entry_simple where mcEntryType in ('MX_ROLE','MX_PRIVILEGE') and mcMskey in

(select mcMskey from idmv_vallink_basic where mcAttrName='MX_APPROVERS'

and mcSearchValue = (select mcmskey from idmv_entry_simple where mcMSKEYVALUE = 'ADMINISTRATOR'))

You might need to extend this to check additional attributes for escalation approvers, additional approval levels etc.

Hope this is more helpful than my first response :-)



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