The USER_TAB_PRIVS view provides information about the object grants for which the current user is the object owner, grantor, or grantee.
| Column name | Data type | Description |
|---|---|---|
GRANTEE |
VARCHAR2(128) |
The name of the user or role whom access was granted to. |
OWNER |
VARCHAR2(128) |
The owner of the object. |
TABLE_NAME |
VARCHAR2(128) |
The name of the object. The object can be any object, including tables, packages, indexes, sequences, and others. |
GRANTOR |
VARCHAR2(128) |
The name of the user who performed the grant. |
PRIVILEGE |
VARCHAR2(40) |
The privilege on the object. |
GRANTABLE |
VARCHAR2(3) |
Specifies whether the privilege was granted with the GRANT OPTION (YES) or not (NO). |
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 |
COMMON |
VARCHAR2(3) |
Specifies how the privilege was granted. The possible values are:
|
TYPE |
VARCHAR2(24) |
The type of the object. |
INHERITED |
VARCHAR2(3) |
Specifies whether the privilege grant was inherited from another container (YES) or not (NO). |