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

网络编程 Oracle 视图 AUDIT_UNIFIED_POLICIES 官方解释，作用，如何使用详细说明 10-15

本站中文解释

Oracle视图 AUDIT_UNIFIED_POLICIES 属于Oracle Data vault审计功能，用于保存所有审计视图和统一政策之间的关系。该视图可用于检索与其他视图相关联的所有统一政策。

使用方法：

首先，在Oracle中定义一个视图，命名为AUDIT_UNIFIED_POLICIES。

然后，使用SELECT语句向该视图添加记录，包括要关联的视图单元格、统一政策名称、描述以及统一政策类型。

最后，使用SELECT语句从该视图中查询所有记录，例如可以查询指定统一政策名称的视图单元格，以及特定类型的统一政策名称的描述。

官方英文解释

AUDIT_UNIFIED_POLICIES describes all audit policies created in the database.

Note:

This view is populated only in an Oracle Database where unified auditing is enabled.

See Oracle Database Security
Guide for more information about unified auditing.
See Oracle Database Upgrade
Guide for more information about migrating to unified auditing.

Column	Datatype	Description
`POLICY_NAME`	`VARCHAR2(128)`	Name of the audit policy
`AUDIT_CONDITION`	`VARCHAR2(4000)`	Condition associated with the audit policy
`CONDITION_EVAL_OPT`	`VARCHAR2(9)`	Evaluation option associated with the audit policy’s condition. The possible values are `STATEMENT`, `SESSION`, `INSTANCE`, and `NONE`.
`AUDIT_OPTION`	`VARCHAR2(128)`	Auditing option defined in the audit policy
`AUDIT_OPTION_TYPE`	`VARCHAR2(18)`	Type of the auditing option. Possible values: `SYSTEM PRIVILEGE` `STANDARD ACTION` `SYSTEM ACTION` `XS ACTION` `OLS_ACTION` `DATAPUMP ACTION` `DIRECT LOAD ACTION` `DV ACTION` `INVALID` `OBJECT ACTION` `ROLE PRIVILEGE`
`OBJECT_SCHEMA`	`VARCHAR2(128)`	Owner of the object, for an object-specific auditing option
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the object, for an object-specific auditing option
`OBJECT_TYPE`	`VARCHAR2(23)`	Type of the object, for an object-specific auditing option
`COMMON`	`VARCHAR2(3)`	Indicates whether the audit policy is a common audit policy or local audit policy. The value is `NULL` for a non-CDB. For local audit policies, the value of the `COMMON` column is always `NO`. For a CDB common policy: If you query `AUDIT_UNIFIED_POLICIES` from the CDB root container, the value of the `COMMON` column will be `YES` and the value of the `INHERITED` column will be `NO`. If you query `AUDIT_UNIFIED_POLICIES` from any other container besides the CDB root container, the value of the `COMMON` column and the `INHERITED` column will be `YES`. For an application container common policy: If you query `AUDIT_UNIFIED_POLICIES` from the application root container, the value of the `COMMON` column will be `YES` and the value of the `INHERITED` column will be `NO`. If you query `AUDIT_UNIFIED_POLICIES` from any other container besides the application root container, the value of the `COMMON` column and the `INHERITED` column will be `YES`.
`INHERITED`	`VARCHAR2(3)`	Indicates whether the audit policy was inherited from another container (`YES`) or not (`NO`). This value is `NULL` for non-CDBs.
`AUDIT_ONLY_TOPLEVEL`	`VARCHAR2(3)`	Indicates whether the audit policy is defined to audit only top level SQL statements (`YES`) or both top level SQL statements and recursive SQL statements (`NO`)
`ORACLE_SUPPLIED`	`VARCHAR2(3)`	Indicates whether the audit policy is an Oracle-supplied policy (`YES`) or not (`NO`) Oracle-supplied policies are also called predefined policies.

编辑：一起学习网

标签：视图,政策,名称,语句,单元格