OKC_TEAM_USER_ENT_ROLES_V
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: VIEW
Columns
Name |
---|
USER_NAME USER_GUID ROLE_CODE ROLE_NAME ROLE_GUID |
Query
SQL_Statement |
---|
SELECT u.username as user_name , u.user_guid , rn.role_common_name AS role_code, rn.role_name, rn.role_guid FROM per_users u, per_user_roles r, per_roles_dn_vl rn WHERE u.user_id = r.user_id(+) AND r.role_guid = rn.role_guid(+) ORDER BY u.username, rn.role_common_name |