Hello All,
I am trying to find all the instances for a resource "Resource - Approve Time" instance right. Below is the query which I have prepared:
select
PER.PRINCIPAL_ID,
CMN.LAST_NAME||', '||CMN.FIRST_NAME User_name,
PER.RIGHT_ID,
SRM.FULL_NAME,
PER.OBJECT_INSTANCE_ID
from cmn_sec_assgnd_obj_perm per,
cmn_sec_users cmn,
srm_resources srm
where per.principal_id=cmn.id
and per.object_instance_id=srm.id
and per.principal_type='USER'
and per.principal_id =5035671
and per.right_id=3632
and SRM.IS_ACTIVE=1
and per.permission_id=50
I checked the result against few resources and it is giving correct result. But, I want to be very sure before including this in a report.
Please, check and let me know if above query is correct or not.
Thanks,
Pragya Singh