VIEW: SYS.KU$_DEFROLE_VIEW

Source

View Text - Preformatted

select '1','0',
          u.user#,
          u.name,
          u.type#,
          u.defrole,
          cast(multiset (select * from ku$_defrole_list_view df
                where df.user_id = u.user#) as ku$_defrole_list_t
                )
  from sys.user$ u
  where (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
                OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, U.USER#
, U.NAME
, U.TYPE#
, U.DEFROLE
, CAST(MULTISET (SELECT *
FROM KU$_DEFROLE_LIST_VIEW DF
WHERE DF.USER_ID = U.USER#) AS KU$_DEFROLE_LIST_T )
FROM SYS.USER$ U
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))