Feature
DBA_COL_PRIVS displays all column object grants in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
USER_COL_PRIVS
Fields
| Field | 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 column name. |
| 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 was granted by using the GRANT option. |