ALL_POLICY_GROUPS

Purpose

This view displays the information about the policy groups of all views accessible to the current user, enabling different policies to be applied to different users based on the policy context.

Columns

Sample query

Query the information about the policy groups of 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 information about the policy groups of views owned by the current user: USER_POLICY_GROUPS

• Query the information about the policy groups of all views in the current tenant: DBA_POLICY_GROUPS