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

本站中文解释

Oracle视图DBA_AUDIT_MGMT_CONFIG_PARAMS存储系统审计管理配置参数。使用该视图可以获取以下审计管理设置:

1. AUDIT_TRAIL:审计跟踪记录类型,有None, DB, Extended, XML和OS四种。

2. AUDIT_SYS_OPERATIONS:Whether system operations should be audited or not

3. AUDIT_SYSLOG:当启用AUDIT_TRAIL时,指定如何监视系统操作日志。

4. MAX_ENABLED_VERSIONS:依据AUDIT_TRAIL参数设置,指定保留的审计记录版本最大值。

使用该视图可以帮助DBA完成对审计管理的设置,扩展系统的安全保护等操作。使用方法如下:

SELECT * FROM DBA_AUDIT_MGMT_CONFIG_PARAMS;

官方英文解释

DBA_AUDIT_MGMT_CONFIG_PARAMS displays information about the currently configured audit trail properties that are used by the DBMS_AUDIT_MGMT PL/SQL package.

Note:

This view is populated in any Oracle Database where auditing is enabled, regardless of whether pre-Oracle Database 12c auditing or unified auditing is enabled for the database.

  • 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

PARAMETER_NAME

VARCHAR2(1024)

NOT NULL

Name of the property

PARAMETER_VALUE

VARCHAR2(4000)

Value of the property

AUDIT_TRAIL

VARCHAR2(28)

Audit trails for which the property is configured:

  • STANDARD AUDIT TRAIL

  • FGA AUDIT TRAIL

  • STANDARD AND FGA AUDIT TRAIL

  • OS AUDIT TRAIL

  • XML AUDIT TRAIL

  • OS AND XML AUDIT TRAIL

  • ALL AUDIT TRAILS

  • UNIFIED AUDIT TRAIL

Note:

In a read-only database, including an Oracle Active Data Guard physical standby database, this view is not populated when the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL PL/SQL procedure is invoked. If the procedure was used when the database was in read-only mode, use DBMS_AUDIT_MGMT.GET_AUDIT_TRAIL to check the value of the property.

See Also:

Oracle Database PL/SQL
Packages and Types Reference
for more information about the parameters specified with the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_PROPERTY procedure


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