VIEW: SYS.EXU9NTAROLE

Source

View Text - Preformatted

SELECT  prd$.role#, ur$.name, uc$.name, up$.name
        FROM    sys.user$ ur$, sys.proxy_role_data$ prd$,
                sys.user$ uc$, sys.user$ up$
        WHERE   prd$.role#   = ur$.user# AND
                prd$.client# = uc$.user# AND
                prd$.proxy#  = up$.user#

View Text - HTML Formatted

SELECT PRD$.ROLE#
, UR$.NAME
, UC$.NAME
, UP$.NAME
FROM SYS.USER$ UR$
, SYS.PROXY_ROLE_DATA$ PRD$
, SYS.USER$ UC$
, SYS.USER$ UP$
WHERE PRD$.ROLE# = UR$.USER# AND PRD$.CLIENT# = UC$.USER# AND PRD$.PROXY# = UP$.USER#