Oracle Fusion SaaS – Query to get Security context details for a User
SELECT Users.username ,asg.role_name,
(SELECT Bu.BU_NAME
FROM fusion.FUN_ALL_BUSINESS_UNITS_V Bu
WHERE Bu.bu_id = Asg.org_id
AND SecMap.OBJECT_NAME = 'FUN_ALL_BUSINESS_UNITS_V'
AND ROWNUM =1
) AS BU_NAME,
(SELECT PK1_COLUMN_NAME
FROM fusion.FND_OBJECTS Obj
WHERE obj.obj_name = secmap.object_name
) AS SECURITY_CONTEXT
FROM FUN_USER_ROLE_DATA_ASGNMNTS asg,
fusion.PER_USERS Users,
fusion.FUN_ROLE_DATA_SECURITY_MAPPING SecMap
where 1=1
AND Users.USER_GUID = Asg.USER_GUID
AND Asg.ROLE_NAME = SecMap.ROLE_NAME
order by asg.creation_date desc,asg.last_update_date desc
Comments |0|
Category: OracleSaaS