Static Data Dictionary Views, 149 of 666

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner or grantor.

USER_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner. This view does not display the OWNER column.

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

"USER_TAB_PRIVS_MADE"