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 |
---|---|---|---|
|
|
Name of the user or role to whom access was granted |
|
|
|
Owner of the object |
|
|
|
Name of the object |
|
|
|
Name of the column |
|
|
|
Name of the user who performed the grant |
|
|
|
Privilege on the column |
|
|
|
Indicates whether the privilege was granted with the |
|
|
|
Indicates how the grant was made. Possible values:
|
See Also: