ALL_COL_PRIVS_RECD

Previous Next JavaScript must be enabled to correctly display this content

2.84 ALL_COL_PRIVS_RECD

ALL_COL_PRIVS_RECD describes the following types of grants:

Column object grants for which the current user is the grantee
Column object grants for which an enabled role or PUBLIC is the grantee

Related View

USER_COL_PRIVS_RECD describes the column object grants for which the current user is the grantee. This view does not display the GRANTEE column.

Column	Datatype	NULL	Description
`GRANTEE`	`VARCHAR2(128)`		Name of the user or role to whom access was granted
`OWNER`	`VARCHAR2(128)`		Owner of the object
`TABLE_NAME`	`VARCHAR2(128)`		Name of the object
`COLUMN_NAME`	`VARCHAR2(128)`		Name of the column
`GRANTOR`	`VARCHAR2(128)`		Name of the user who performed the grant
`PRIVILEGE`	`VARCHAR2(40)`		Privilege on the column
`GRANTABLE`	`VARCHAR2(3)`		Indicates whether the privilege was granted with the `GRANT OPTION` (`YES`) or not (`NO`)
`COMMON`	`VARCHAR2(3)`		Indicates how the grant was made. Possible values: `YES` if the privilege was granted commonly (`CONTAINER=ALL` was used) `NO` if the privilege was granted locally (`CONTAINER=ALL` was not used)
`INHERITED`	`VARCHAR2(3)`		Indicates whether the privilege grant was inherited from another container (`YES`) or not (`NO`)

See Also:

"USER_COL_PRIVS_RECD"