Purpose
The ALL_SEC_RELEVANT_COLS view displays the column-level strategies associated with a specified column.
Note
This view is introduced since OceanBase Database V4.1.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OBJECT_OWNER | VARCHAR2(128) | YES | The owner of the object controlled by the strategy. |
| OBJECT_NAME | VARCHAR2(128) | YES | The name of the object controlled by the strategy. |
| POLICY_GROUP | VARCHAR2(128) | NO | The name of the strategy group. |
| POICY_NAME | VARCHAR2(128) | NO | The name of the strategy. |
| SEC_REL_COLUMN | VARCHAR2(128) | YES | The name of the column associated with the column-level strategy. |
| COLUMN_OPTION | VARCHAR2(8) | NO | The strategy option. Valid values:
|
| COMMON | VARCHAR2(3) | NO | This column is used only for compatibility, and the value is fixed to NO. |
| INHERITED | VARCHAR2(3) | NO | This column is used only for compatibility, and the value is fixed to NO. |