I am trying to find all the instances for a resource "Resource - Approve Time" instance right. Below is the query which I have prepared:
CMN.LAST_NAME||', '||CMN.FIRST_NAME User_name,
from cmn_sec_assgnd_obj_perm per,
and per.principal_id =5035671
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.