Note
- For OceanBase Database V4.3.x, this view was introduced in OceanBase Database V4.3.2.
- For OceanBase Database V4.2.x, this variable was introduced in OceanBase Database V4.2.3.
Purpose
The PROXY_USERS view displays the proxy information of users.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PROXY | VARCHAR2(128) | NO | The name of the proxy user. |
| CLIENT | VARCHAR2(128) | NO | The name of the target user corresponding to the proxy user. |
| AUTHENTICATION | VARCHAR2(3) | NO | Specifies whether the proxy user needs to provide the credential of the target user. Valid values:
|
| FLAGS | VARCHAR2(35) | NO | The additional proxy information. Valid values:
PROXY MAY ACTIVATE ALL CLIENT ROLES is supported. |
Sample query
Query the proxy information of users.
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 |
+-------+--------+----------------+-------------------------------------+