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