Purpose
The ALL_TAB_PRIVS view displays the following types of object privileges:
Object privileges for which the current user is the object owner, grantor, or grantee
Object privileges for which an enabled role or PUBLIC is the grantee
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_TAB_PRIVS
USER_TAB_PRIVS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| GRANTOR | VARCHAR2(128) | NO | The username of the user who performed the grant. |
| GRANTEE | VARCHAR2(128) | NO | The username of the user to whom the access privilege was granted. |
| TABLE_SCHEMA | VARCHAR2(128) | NO | The schema of the object. |
| TABLE_NAME | VARCHAR2(128) | NO | The object name. |
| 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. |