VIEW: SYS.PROXY_USERS_AND_ROLES

Source

View Text - Preformatted

select u.proxy,
       u.client,
       u.flags,
       r.role
from sys.proxy_users u, sys.proxy_roles r
where u.proxy  = r.proxy
  and u.client = r.client

View Text - HTML Formatted

SELECT U.PROXY
, U.CLIENT
, U.FLAGS
, R.ROLE FROM SYS.PROXY_USERS U
, SYS.PROXY_ROLES R WHERE U.PROXY = R.PROXY
AND U.CLIENT = R.CLIENT