Note
This view is available starting with V2.2.77.
Purpose
Describes the object privileges granted in the database.
Applicability
This view is available only in Oracle-compatible mode of OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The username of the user to whom the 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 grants the privilege. |
| PRIVILEGE | VARCHAR2(40) | NO | The privilege of the object. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the privilege can be granted by using the GRANT OPTION. |
| HIERARCHY | VARCHAR2(10) | NO | Indicates whether the privilege can be granted by using the HIERARCHY OPTION. |
Sample query
Query the object privileges granted to the TEST3 user.
obclient [SYS]> SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE='TEST3';
The query result is as follows:
+---------+-------+------------+---------+-----------+-----------+-----------+
| GRANTEE | OWNER | TABLE_NAME | GRANTOR | PRIVILEGE | GRANTABLE | HIERARCHY |
+---------+-------+------------+---------+-----------+-----------+-----------+
| TEST3 | SYS | TBL3 | SYS | SELECT | NO | NO |
| TEST3 | SYS | TBL3 | SYS | UPDATE | NO | NO |
+---------+-------+------------+---------+-----------+-----------+-----------+
2 rows in set