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';
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';
Thank you Anand!
ReplyDeleteWe 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
ReplyDeletedate related Audit tables in OIM?