Query to find the list of all entitlements of a user for a given application instance in OIM
select usr.usr_login,app_instance.app_instance_name,ent_list.ent_display_name,ent_assign.ent_status from ent_assign
join usr on usr.usr_key = ent_assign.usr_key and usr.usr_login = upper('Given user login here')
join ent_list on ent_list.ent_list_key = ent_assign.ent_list_key
join app_instance on ent_list.obj_key = app_instance.object_key and ent_list.svr_key = app_instance.itresource_key
where app_instance.app_instance_name = 'Give App Instance Name here'
No comments:
Post a Comment