Oracle教程 2023-02-23

Oracle 视图 ALL_POLICY_GROUPS 官方解释，作用，如何使用详细说明

ALL_POLICY_GROUPS视图提供了有关数据库行政策组的信息，行政策组是Oracle Database Vault中控制领域用户访问数据库资源行为的一种方法。

使用方法：

查询所有行政策组：

SELECT * FROM ALL_POLICY_GROUPS;

查询指定名称的行政策：

SELECT * FROM ALL_POLICY_GROUPS WHERE group_name = ‘XYZ’;

ALL_POLICY_GROUPS describes the policy groups defined for the synonyms, tables, and views accessible to the current user.

Related Views

DBA_POLICY_GROUPS describes all policy groups in the database.
USER_POLICY_GROUPS describes the policy groups defined for the synonyms, tables, and views owned by the current user. This view does not display the OBJECT_OWNER column.

Column	Datatype	Description
`OBJECT_OWNER`	`VARCHAR2(128)`	Owner of the synonym, table, or view
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the synonym, table, or view
`POLICY_GROUP`	`VARCHAR2(128)`	Name of the policy group
`COMMON`	`VARCHAR2(3)`	Indicates whether the policy group is applied and enforced in all application PDBs (`YES`) or only in the local PDB (`NO`)
`INHERITED`	`VARCHAR2(3)`	Indicates whether the policy group is inherited from the root (`YES`) or not (`NO`)