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'