Definition:
The Oracle USER_TAB_PRIVS function describes the object grants for which the current user is the object owner, grantor, or grantee. Its columns are the same as those in DBA_TAB_PRIVS.
Column | Datatype | NULL | Description |
GRANTEE | VARCHAR2(30) | NOT NULL | Name of the user to whom access was granted |
OWNER | VARCHAR2(30) | NOT NULL | Owner of the object |
TABLE_NAME | VARCHAR2(30) | NOT NULL | Name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on. |
GRANTOR | VARCHAR2(30) | NOT NULL | Name of the user who performed the grant |
PRIVILEGE | VARCHAR2(40) | NOT NULL | Privilege on the object |
GRANTABLE | VARCHAR2(3) | | Indicates whether the privilege was granted with the GRANT OPTION (YES ) or not (NO ) |
HIERARCHY | VARCHAR2(3) | | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES ) or not (NO ) |
Related Links: