Purpose
ALL_COL_PRIVS displays the following types of object privileges:
Column object privileges for which the current user is the object owner, grantor, or grantee
Column object privileges for which an enabled role or PUBLIC is the grantee
Related views
DBA_COL_PRIV
USER_COL_PRIV
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| GRANTOR | VARCHAR2(128) | NO | The username of the user who performed the grant. |
| 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. |
| PRIVILLEGE | VARCHAR2(40) | NO | The privilege on the column. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the privilege was granted by using the GRANT option. |