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 MySQL mode.
Related views
ALL_TAB_PRIVS
USER_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 object name. |
| 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. |