Get Started with Redwood for Oracle Cloud HCM Begin Now
SQL to fetch the security profiles attached to a data role.
Summary:
SQL to fetch the security profiles attached to a data role.
Content (required):
SQL to fetch the security profiles attached to a data role.
Version (include the version you are using, if applicable):
23C
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT roledn.role_name as role,roledn.role_common_name as role_code,roledn.role_id,
(SELECT NVL(sec.name,'Missing Person Security Profile')
FROM fusion.per_gen_data_role_profiles gdrp_per
,fusion.per_person_security_profiles sec
WHERE gdrp_per.generated_data_role_id = gen.generated_data_role_id
AND gdrp_per.hr_securing_object = 'PERSON'
Tagged:
0