Overview
DBA_TAB_PRIVS describes all object grants in the database.
Related views
USER_TAB_PRIVS
Field description
| Field name | 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 granted the privilege. |
| 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(3) | NO | Indicates whether the privilege was granted by using the HIERARCHY option. |