Note
This view is available starting with V2.2.77.
Purpose
ALL_COL_PRIVS describes the following types of privileges:
Column object privileges granted to the current user as the object owner, grantor, or grantee
Column object privileges enabled for roles or granted to PUBLIC
Applicability
This view is available only in OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| GRANTOR | VARCHAR2(128) | NO | The name of the user who executed the GRANT statement. |
| GRANTEE | VARCHAR2(128) | NO | The name of the user to whom the privilege is 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 of the column. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the GRANT option is used. |