Oracle教程 2023-03-31

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

Oracle视图AUDIT_UNIFIED_ENABLED_POLICIES用于存储从Unified Audit启用之前给定的审计策略的列表。它位于架构AUDIT_VIEWS中，帮助在审计或审核时跟踪配置改变。

AUDIT_UNIFIED_ENABLED_POLICIES视图结构如下：

POLICY_NAMES：审计策略的名称

POLICY_ENABLED：策略是否启用

ENABLED_DATE：最近更改的日期

ENABLED_BY：最近更新的用户

使用AUDIT_UNIFIED_ENABLED_POLICIES视图，可以对某个时间段内给定策略的启用情况进行监视和跟踪。可以使用下面的SELECT语句查询AUDIT_UNIFIED_ENABLED_POLICIES视图，用以检查哪些策略已经启用：

SELECT POLICY_NAMES, POLICY_ENABLED, ENABLED_DATE, ENABLED_BY
FROM AUDIT_UNIFIED_ENABLED_POLICIES
WHERE POLICY_ENABLED=’YES’;

AUDIT_UNIFIED_ENABLED_POLICIES describes all the audit policies that are enabled 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
`ENABLED_OPTION`	`VARCHAR2(15)`	Enabled option of the audit policy. Possible values: `BY USER`: For policies that are enabled on users `EXCEPT USER`: For policies that are enabled on users `BY GRANTED ROLE`: For policies that are enabled on roles `INVALID`: For policies that are not enabled on either users or roles
`ENTITY_NAME`	`VARCHAR2(128)`	Database entity (user name or role name) on which the audit policy is enabled. When an audit policy is enabled on all database users, `ALL USERS` is displayed in this column.
`ENTITY_TYPE`	`VARCHAR2(7)`	Database entity type. Possible values: `USER`: Indicates that the policy is enabled on a user or users. `ROLE`: Indicates that the policy is enabled on a role or roles.
`SUCCESS`	`VARCHAR2(3)`	Indicates whether the audit policy is enabled for auditing successful events (`YES`) or not (`NO`)
`FAILURE`	`VARCHAR2(3)`	Indicates whether the audit policy is enabled for auditing unsuccessful events (`YES`) or not (`NO`)

分享到：