Note
This view is available starting with V4.1.0.
Purpose
This view displays the policy group information for all views accessible to the current user. 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 accessible to the current user.
obclient [SYS]> SELECT * FROM SYS.ALL_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 owned by the current user: USER_POLICY_GROUPS
Query the policy group information for all views in the current tenant: DBA_POLICY_GROUPS