VIEW: SYS.PROXY_ROLES

Source

View Text - Preformatted

select u1.name,
       u2.name,
       u3.name
from sys.user$ u1, sys.user$ u2, sys.user$ u3, sys.proxy_role_info$ p
where u1.user# = p.proxy#
  and u2.user# = p.client#
  and u3.user# = p.role#

View Text - HTML Formatted

SELECT U1.NAME
, U2.NAME
, U3.NAME FROM SYS.USER$ U1
, SYS.USER$ U2
, SYS.USER$ U3
, SYS.PROXY_ROLE_INFO$ P WHERE U1.USER# = P.PROXY#
AND U2.USER# = P.CLIENT#
AND U3.USER# = P.ROLE#