USER_POLICY_GROUPS

Purpose

This view displays the policy groups of the views owned by the current user. It works with policy contexts to apply different policies to different users.

Columns

Sample query

Query the policy groups of the views owned by the current user.

obclient [SYS]> SELECT * FROM SYS.USER_POLICY_GROUPS;

The query result is as follows:

+----------------+--------------+--------+-----------+
| OBJECT_NAME    | POLICY_GROUP | COMMON | INHERITED |
+----------------+--------------+--------+-----------+
| V_SALES_SECURE | GROUP_SALES  | NO     | NO        |
| V_ORDERS_CTX   | GROUP_REGION | NO     | NO        |
+----------------+--------------+--------+-----------+
2 rows in set

References

• Query the policy groups of the views accessible to the current user: ALL_POLICY_GROUPS

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