Purpose
The DBA_COL_PRIVS view displays all column object privileges 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
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 was granted by using the GRANT option. |