Oracle教程

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

本站中文解释

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 NULL 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.


数据运维技术 » Oracle 视图 AUDIT_UNIFIED_POLICIES 官方解释，作用，如何使用详细说明
分享到：

相关推荐