Purpose
This view describes the following types of column object privileges:
Column object privileges granted to the current user as the owner, grantor, or grantee.
Column object privileges granted to the PUBLIC role or to a grantee.
Applicability
This view is available only in OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| GRANTOR | VARCHAR2(128) | NO | The name of the user who executed the grant statement. |
| GRANTEE | VARCHAR2(128) | NO | The name of the user who was 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. |
| PRIVILLEGE | VARCHAR2(40) | NO | The privilege of the column. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the grant option is used. |