Note
This view is available starting with V2.2.77.
Purpose
This view describes the column privileges granted in the database.
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 has been granted access privileges. |
| 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 executed the grant operation. |
| PRIVILEGE | VARCHAR2(40) | NO | The privileges on the column. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the grant option was used. |