VIEW: SYS.EXU8DFR

Source

View Text - Preformatted

SELECT  u$.name, u$.user#, u1$.name, u1$.user#
        FROM    sys.user$ u$, sys.user$ u1$, sys.defrole$ d$
        WHERE   u$.user# = d$.user# AND
                u1$.user# = d$.role#

View Text - HTML Formatted

SELECT U$.NAME
, U$.USER#
, U1$.NAME
, U1$.USER#
FROM SYS.USER$ U$
, SYS.USER$ U1$
, SYS.DEFROLE$ D$
WHERE U$.USER# = D$.USER# AND U1$.USER# = D$.ROLE#