Note
This view is available starting with V2.2.77.
Purpose
This view describes the column privileges granted to the current user as the owner, grantor, or grantee.
Note
Oracle-compatible mode of OceanBase Database does not support column privileges.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The name of the user who is granted the privilege. |
| 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 who grants the privilege. |
| PRIVILEGE | VARCHAR2(40) | NO | The privilege granted on the column. |
| GRANTABLE | VARCHAR2(3) | NO | Whether the GRANT statement can be used to grant the privilege. |