VIEW: SYS.KU$_DEFROLE_LIST_VIEW

Source

View Text - Preformatted

select  d$.user#, u$.name, u1$.name, d$.role#
  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 D$.USER#
, U$.NAME
, U1$.NAME
, D$.ROLE#
FROM SYS.USER$ U$
, SYS.USER$ U1$
, SYS.DEFROLE$ D$
WHERE U$.USER# = D$.USER# AND U1$.USER# = D$.ROLE#