Overview
ALL_COL_PRIVS describes the object grants that meet the following conditions:
The current user is the object owner, grantor, or grantee.
An enabled or PUBLIC role is the grantee.
Related views
DBA_COL_PRIV
USER_COL_PRIV
Field description
| Field name | 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. |