Overview
ALL_TAB_PRIVS describes the object grants that meet the following conditions:
The current user is the object owner, grantor, or grantee.
An enabled or PUBLIC role is the grantee.
Related views
DBA_TAB_PRIVS
USER_TAB_PRIVS
Field description
| Field name | 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 name of the object. |
| 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. |