ALL_TAB_PRIVS

ALL_TAB_PRIVS describes the following types of grants:

• Object grants for which the current user is the object owner, grantor, or grantee
• Object grants for which an enabled role or PUBLIC is the grantee

Related Views

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

  Column	Datatype	NULL	Description
  GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
  GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
  TABLE_SCHEMA	VARCHAR2(30)	NOT NULL	Schema of the object
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
  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)

  See Also: "DBA_TAB_PRIVS" "USER_TAB_PRIVS"