Static Data Dictionary Views, 24 of 625

ALL_COL_PRIVS_RECD

ALL_COL_PRIVS_RECD describes column object grants for which the current user or PUBLIC is the grantee.

USER_COL_PRIVS_RECD describes column object grants for which the current user is the grantee. 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 NUL`	Name of the owner of the object
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object
`COLUMN_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 column
`GRANTABLE`	`VARCHAR2(3)`		Whether the privilege was granted with `ADMIN` `OPTION` (`YES` \| `NO`)