Note
This view is available starting with V4.1.0.
Purpose
This view displays the policy group information for all views in the current tenant. It works with policy contexts to apply different policies to different users.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OBJECT_OWNER | VARCHAR2(128) | YES | The owner of the object controlled by the policy. |
| OBJECT_NAME | VARCHAR2(128) | YES | The name of the object controlled by the policy. |
| POLICY_GROUP | VARCHAR2(128) | NO | The name of the policy group. |
| COMMON | VARCHAR2(3) | NO | Reserved for compatibility. The value is fixed to NO. |
| INHERITED | VARCHAR2(3) | NO | Reserved for compatibility. The value is fixed to NO. |
Sample query
Query the policy group information for all views in the current tenant.
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
Query the policy group information for views accessible to the current user: ALL_POLICY_GROUPS
Query the policy group information for views owned by the current user: USER_POLICY_GROUPS