Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_PROXIES

DBA_PROXIES displays Information about all proxy connections in the database.


Related View

USER_PROXIES displays information about connections the current user is allowed to proxy. This view does not display the PROXY column.

Column Datatype NULL Description
PROXY VARCHAR2(30) NOT NULL Name of the proxy user
CLIENT VARCHAR2(30) NOT NULL Name of the client user who the proxy user can act on behalf of
AUTHENTICATION VARCHAR2(3)   Indicates whether the proxy is required to supply the client's authentication credentials (YES) or not (NO)
AUTHORIZATION_CONSTRAINT VARCHAR2(35)
Indicates the proxy's authority to exercise roles on the client's behalf:
  • PROXY MAY ACTIVATE ALL CLIENT ROLES

  • NO CLIENT ROLES MAY BE ACTIVATED

  • PROXY MAY ACTIVATE ROLE

  • PROXY MAY ACTIVATE ALL CLIENT ROLES

  • PROXY MAY NOT ACTIVATE ROLE

ROLE VARCHAR2(30)
Name of the role referenced in AUTHORIZATION_CONSTRAINT


See Also:

"USER_PROXIES"