Oracle教程 2023-02-23

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

ALL_POLICY_CONTEXTS，这是Oracle数据库系统中可以用于管理安全策略的一种系统视图。它能够提供全面的信息，它会记录策略的内容，以及关联的表、视图和类别，并将每个关系的上下文在一起。

使用这个视图，可以快速地查询哪些表、视图和类别被用来运行某个策略，而不是将对策略所需的上下文信息重新定位。另外，它也可以用来快速获取某个指定表始终被加载的策略的相关信息，如策略的名称等。

ALL_POLICY_CONTEXTS describes the driving contexts defined for the synonyms, tables, and views accessible to the current user.

Related Views

DBA_POLICY_CONTEXTS describes all driving contexts in the database.
USER_POLICY_CONTEXTS describes the driving contexts defined for the synonyms, tables, and views owned by the current user. This view does not display the OBJECT_OWNER column.

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