Note
This view is available starting with V2.2.77.
Purpose
This view displays the object privileges granted to the current user.
Applicability
This view is available only in Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The username of the user to whom the access privilege is granted. |
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object. |
| GRANTOR | VARCHAR2(128) | NO | The username of the user who executed the grant operation. |
| PRIVILEGE | VARCHAR2(40) | NO | The privileges of the object. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the privileges can be granted by using the GRANT OPTION. |
| HIERARCHY | VARCHAR2(10) | NO | Indicates whether the privileges can be granted by using the HIERARCHY OPTION. |
Sample query
Query the object privileges granted to the current user.
obclient [TEST3]> SELECT * FROM USER_TAB_PRIVS;
The query result is as follows:
+---------+-------+------------+---------+-----------+-----------+-----------+
| GRANTEE | OWNER | TABLE_NAME | GRANTOR | PRIVILEGE | GRANTABLE | HIERARCHY |
+---------+-------+------------+---------+-----------+-----------+-----------+
| TEST3 | SYS | TBL3 | SYS | UPDATE | NO | NO |
| TEST3 | SYS | TBL3 | SYS | SELECT | NO | NO |
+---------+-------+------------+---------+-----------+-----------+-----------+
2 rows in set