AnsweredAssumed Answered

Instance right query

Question asked by sparc.helpdesk on Dec 17, 2014
Latest reply on Dec 17, 2014 by sparc.helpdesk

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

Outcomes