OKC_TEAM_USER_ENT_ROLES_V

詳細

名前
USER_NAME USER_GUID ROLE_CODE ROLE_NAME ROLE_GUID

名前

USER_NAME

USER_GUID

ROLE_CODE

ROLE_NAME

ROLE_GUID

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

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