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