Note
This view is available starting with V2.2.77.
Purpose
Describes all column privileges granted in the database.
Note
Oracle mode of OceanBase Database does not support column privileges.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The name of the user to which 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. |
| GRANTOR | VARCHAR2(128) | NO | The name of the user that grants the privilege. |
| PRIVILEGE | VARCHAR2(40) | NO | The privilege on the column. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the grantor can grant the privilege to other users. |