SYS.ALL_TAB_PRIVS

The ALL_TAB_PRIVS view lists 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.

Related views

SYS.DBA_TAB_PRIVS describes all object grants in the database.
SYS.USER_TAB_PRIVS describes the object grants for which the current user is the object owner, grantor, or grantee.

Columns

Column	Type	Description
GRANTOR	VARCHAR2(30) NOT NULL	Name of the user who granted the privilege
GRANTEE	VARCHAR2(30) NOT NULL	Name of the user who has the privilege
TABLE_SCHEMA	VARCHAR2(30) NOT NULL	Object owner
TABLE_NAME	VARCHAR2(31) NOT NULL	Object name
PRIVILEGE	VARCHAR2(40) NOT NULL	Privilege name
GRANTABLE	VARCHAR2(3) NOT NULL	Value is always NO.
HIERARCHY	VARCHAR2(3) NOT NULL	Value is always NO.