Note
This view is introduced since OceanBase Database V4.1.0.
Purpose
The USER_SEC_RELEVANT_COLS view displays the column-level strategies associated with a specified column.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| 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. |
Sample query
Query information about all columns associated with a strategy in the tables or views that the current user owns.
obclient [SYS]> SELECT * FROM SYS.USER_SEC_RELEVANT_COLS;
The query result is as follows:
+----------------+--------------+----------------+----------------+---------------+--------+-----------+
| OBJECT_NAME | POLICY_GROUP | POLICY_NAME | SEC_REL_COLUMN | COLUMN_OPTION | COMMON | INHERITED |
+----------------+--------------+----------------+----------------+---------------+--------+-----------+
| V_SALES_SECURE | GROUP_SALES | POLICY_REGION | AMOUNT | NONE | NO | NO |
| V_ORDERS_CTX | GROUP_REGION | POLICY_DYNAMIC | AMOUNT | NONE | NO | NO |
+----------------+--------------+----------------+----------------+---------------+--------+-----------+
2 rows in set
References
To query information about all columns associated with a strategy in the tables or views of the current tenant, see DBA_SEC_RELEVANT_COLS.
To query information about all columns associated with a strategy in the tables or views that the current user can access, see ALL_SEC_RElevant_COLS.