Note
This view is introduced since OceanBase Database V4.1.0.
Purpose
The DBA_POLICY_GROUPS view displays information about the strategy group that takes effect for different users based on the strategy context.
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. |
| 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
To view the strategy groups of all views in the current tenant, execute the following statement:
obclient [SYS]> SELECT * FROM SYS.DBA_POLICY_GROUPS;
The query result is as follows:
+--------------+----------------+--------------+--------+-----------+
| OBJECT_OWNER | OBJECT_NAME | POLICY_GROUP | COMMON | INHERITED |
+--------------+----------------+--------------+--------+-----------+
| SYS | V_ORDERS_CTX | GROUP_REGION | NO | NO |
| SYS | V_SALES_SECURE | GROUP_SALES | NO | NO |
+--------------+----------------+--------------+--------+-----------+
2 rows in set
References related
To view the strategy groups of views that the current user can access: ALL_POLICY_GROUPS
To view the strategy groups of views owned by the current user: USER_POLICY_GROUPS