DBA_PROXIES view tips

Oracle Tips by Burleson Consulting

DBA_PROXIES

<< Return to the index

Oracle 11g makes the following comments about the DBA_PROXIES table: "Information about all proxy connections"

Related notes on DBA_PROXIES:

Column description of the DBA_PROXIES view:

PROXY

Description of DBA_PROXIES.PROXY: "Name of the proxy user"

CLIENT

Description of DBA_PROXIES.CLIENT: "Name of the client user who the proxy user can act on behalf of"

AUTHENTICATION

Description of DBA_PROXIES.AUTHENTICATION: "Indicates whether proxy is required to supply client's authentication credentials"

AUTHORIZATION_CONSTRAINT

Description of DBA_PROXIES.AUTHORIZATION_CONSTRAINT: "Indicates the proxy's authority to exercise roles on client's behalf"

ROLE

Description of DBA_PROXIES.ROLE: "Name of the role referenced in authorization constraint"

PROXY_AUTHORITY

Description of DBA_PROXIES.PROXY_AUTHORITY: "Indicates where proxy permissions are managed"

DBA_PROXIES View Source

Oracle 11g's data dictionary defines the DBA_PROXIES view using the following source query:

select u1.name,
u2.name,
decode(p.credential_type#, 0, 'NO',
5, 'YES'),
decode(p.flags, 0, null,
1, 'PROXY MAY ACTIVATE ALL CLIENT ROLES',
2, 'NO CLIENT ROLES MAY BE ACTIVATED',
4, 'PROXY MAY ACTIVATE ROLE',
5, 'PROXY MAY ACTIVATE ALL CLIENT ROLES',
8, 'PROXY MAY NOT ACTIVATE ROLE',
16, 'PROXY MAY ACTIVATE ALL CLIENT ROLES'),
(select u.name from sys.user$ u where pr.role# = u.user#),
case p.flags when 16 then 'DIRECTORY' else 'DATABASE' end
from sys.user$ u1, sys.user$ u2,
sys.proxy_info$ p, sys.proxy_role_info$ pr
where u1.user#(+) = p.proxy#
and u2.user# = p.client#
and p.proxy# = pr.proxy#(+)
and p.client# = pr.client#(+)

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books