The ALL_TAB_PRIVS view provides information about the object privileges granted to the current user, the object privileges granted by the current user, the list of object privileges granted for objects owned by the current user, and the object privileges granted to PUBLIC.
| Column name | Data type | Description |
|---|---|---|
GRANTOR |
VARCHAR2(30) |
The name of the user who granted the privilege. Always INLINE. |
GRANTEE |
VARCHAR2(30) |
The name of the user who has the privilege. Always INLINE. |
TABLE_SCHEMA |
VARCHAR2(30) |
The schema of the object. Always INLINE. |
TABLE_NAME |
VARCHAR2(30) |
The name of the object. Always INLINE. |
PRIVILEGE |
VARCHAR2(40) |
The privilege name. Always INLINE. |
GRANTABLE |
VARCHAR2(3) |
Specifies whether the privilege was granted with the GRANT OPTION (YES) or not (NO).Always NOT NULL, INLINE. |
HIERARCHY |
VARCHAR2(3) |
Specifies whether the GRANTEE has the REFERENCES privilege with the HIERARCHY OPTION on all subobjects of the specified table. The possible values are:
Always NO, NOT NULL, INLINE. |