Saturday, 16 June 2018

OIM - SQL Query to Get Members of Admin Role.

select usr.usr_login
from admin_role_membership,admin_role,usr
where admin_role_membership.user_id = usr.usr_key
and admin_role_membership.role_id = admin_role.role_id
and admin_role.role_name = 'OrclOIMSystemAdministrator';


2 comments:

  1. Thank you Anand!

    ReplyDelete
  2. We need to have date of assignment of Admin role to user. I am not able to get it from any of the tables. Are there any specific role assignment
    date related Audit tables in OIM?

    ReplyDelete