VIEW: SYS.KU$_PROXY_VIEW

Source

View Text - Preformatted

select  u.user#, u.name, up.name, pi.flags,
          pi.credential_type#,
          cast(multiset (select * from ku$_proxy_role_list_view pr
                where pr.client= u.name AND pr.proxy=up.name)
                as ku$_proxy_role_list_t)
  from   sys.user$ u, sys.user$ up, sys.proxy_info$ pi
  where  pi.client# = u.user# AND
         pi.proxy# = up.user#(+)
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
                OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT U.USER#
, U.NAME
, UP.NAME
, PI.FLAGS
, PI.CREDENTIAL_TYPE#
, CAST(MULTISET (SELECT *
FROM KU$_PROXY_ROLE_LIST_VIEW PR
WHERE PR.CLIENT= U.NAME
AND PR.PROXY=UP.NAME) AS KU$_PROXY_ROLE_LIST_T)
FROM SYS.USER$ U
, SYS.USER$ UP
, SYS.PROXY_INFO$ PI
WHERE PI.CLIENT# = U.USER# AND PI.PROXY# = UP.USER#(+)
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))