Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
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
Contact Us

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 or PROXY_AUTHORITY columns.

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
PROXY_AUTHORITY VARCHAR2(9)   Value is either:
  • DIRECTORY if EUS proxy is enabled for that database user

  • DATABASE if this row describes a local proxy permission


See Also:

"USER_PROXIES"