Purpose
The USER_COL_PRIVS view displays column object grants for which the current user is the object owner, grantor, or grantee.
Note
The privilege on columns is not supported at present.
Related views
DBA_COL_PRIVS
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The username of the user to whom the access privilege was granted. |
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the object. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column. |
| GRANTOR | VARCHAR2(128) | NO | The username of the user who granted the privilege. |
| PRIVILEGE | VARCHAR2(40) | NO | The privilege on the column. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the privilege can be granted by using the GRANT option. |