Static Data Dictionary Views, 143 of 625

ALL_TAB_PRIVS

ALL_TAB_PRIVS lists the grants on objects where the user or PUBLIC is the grantee. This view does not display the OWNER column.

DBA_TAB_PRIVS lists all grants on all objects in the database. This view does not display the TABLE_SCHEMA column.

USER_TAB_PRIVS lists grants on all objects where the current user is the grantee. This view does not display the TABLE_SCHEMA column.

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 is granted
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object
`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)`		`YES` if the privilege was granted with `ADMIN` `OPTION`; otherwise `NO`