Tech Trainings

Oracle Fusion SaaS – Query to get Security context details for a User

July 10, 2020 by admin

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|