Oracle: PROXY_USERS

select
-- prx.proxy,
   prx.client,
   prx.authentication,
   prx.flags,
   usp.proxy_only_connect   proxy_only_proxy,
   usc.proxy_only_connect   proxy_only_client,
   usp.authentication_type  auth_type_proxy,
   usc.authentication_type  auty_type_client
from
   proxy_users prx                                left join
   dba_users   usp  on prx.proxy  = usp.username  left join
   dba_users   usc  on prx.client = usp.username 
where
   prx.proxy  = 'RNY'
-- prx.client = 'XXX'
order by

   prx.client;