Purpose
The DBA_TAB_PRIVS view displays all object grants in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_TAB_PRIVSUSER_TAB_PRIVS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The username of the user to whom the access privilege was 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 performed the grant. |
| PRIVILEGE | VARCHAR2(40) | NO | The privilege on the object. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the privilege was granted by using the GRANT option. |
| HIERARCHY | VARCHAR2(10) | NO | Indicates whether the privilege was granted by using the HIERARCHY option. |