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

本站中文解释

Oracle视图DBA_AUDIT_POLICIES用于检索所有已创建的审计策略(auditing)的信息。它可以用于判断在一个特定的数据库实例上定义的审计策略是否有足够的审计条件来确保所要求的策略完成。此外,它也可以用于检查当前为特定操作设置的审计策略是否符合要求以及当前安装审计表空间的大小。

使用方法:
可以使用以下SQL查询来检索某个特定的审计策略的详细信息:

SELECT policy_name, policy_category, policy_type, statement_types, object_names
FROM dba_audit_policies
WHERE policy_name=”;

官方英文解释

DBA_AUDIT_POLICIES describes all fine-grained auditing policies in the database. Its columns are the same as those in ALL_AUDIT_POLICIES.

Note:

This view is populated only in an Oracle Database where unified auditing is not enabled. When unified auditing is enabled in Oracle Database, the audit records are populated in the new audit trail and can be viewed from UNIFIED_AUDIT_TRAIL.

  • See Oracle Database Security
    Guide
    for more information about unified auditing.

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

See Also:

“ALL_AUDIT_POLICIES”


数据运维技术 » Oracle 视图 DBA_AUDIT_POLICIES 官方解释,作用,如何使用详细说明