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 name	Type	Description
GRANTOR	VARCHAR2(30) INLINE	Name of the user who granted the privilege
GRANTEE	VARCHAR2(30) INLINE	Name of the user who has the privilege
TABLE_SCHEMA	VARCHAR2(30) INLINE	Object owner
TABLE_NAME	VARCHAR2(30) INLINE	Object name
PRIVILEGE	VARCHAR2(40) INLINE NOT NULL	Privilege name
GRANTABLE	VARCHAR2(3) INLINE NOT NULL	Value NO
HIERARCHY	VARCHAR2(3) INLINE NOT NULL	Value NO