USER_POLICY_GROUPS

Purpose

The USER_POLICY_GROUPS view displays information about the strategy group that takes effect for different users based on the strategy context.

Columns

Sample query

Query the strategy group information of the views that the current user owns.

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 strategy group information of the views that the current user can access: ALL_POLICY_GROUPS

• Query the strategy group information of all views in the current tenant: DBA_POLICY_GROUPS