Note
- This view is available starting with V4.3.2 in V4.3.x.
- This view is available starting with V4.2.3 in V4.2.x.
Purpose
The PROXY_USERS view displays information about proxy users.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PROXY | VARCHAR2(128) | NO | The name of the proxy user. |
| CLIENT | VARCHAR2(128) | NO | The name of the client user. |
| AUTHENTICATION | VARCHAR2(3) | NO | Indicates whether the proxy user needs to provide the client user's credentials:
|
| FLAGS | VARCHAR2(35) | NO | Records additional information about the proxy:
|
Sample query
Query the proxy user information.
obclient [SYS]> SELECT * FROM SYS.PROXY_USERS WHERE ROWNUM = 1;
The query result is as follows:
+-------+--------+----------------+-------------------------------------+
| PROXY | CLIENT | AUTHENTICATION | FLAGS |
+-------+--------+----------------+-------------------------------------+
| U1 | U1 | NO | PROXY MAY ACTIVATE ALL CLIENT ROLES |
| U3 | U2 | NO | PROXY MAY ACTIVATE ALL CLIENT ROLES |
| U3 | U1 | NO | PROXY MAY ACTIVATE ALL CLIENT ROLES |
| U4 | U2 | NO | PROXY MAY ACTIVATE ALL CLIENT ROLES |
| U4 | U1 | NO | PROXY MAY ACTIVATE ALL CLIENT ROLES |
+-------+--------+----------------+-------------------------------------+