Finding Role & Role Approver info in IDM 7.2
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.
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 :-)