Go Up
You are here: ConfigurationConfigure IT InfrastructureOracle DatabaseVerify Your Oracle Database Audit Settings

Verify Your Oracle Database Audit Settings

You can verify your Oracle Database audit settings manually. Do one of the following, depending on your Oracle Database version and edition.

Oracle Database version/edition Command
Oracle Database 19c (Unified Auditing) select ENTITY_NAME, ENABLED_OPTION, SUCCESS, FAILURE from AUDIT_UNIFIED_ENABLED_POLICIES;

Oracle Database 12c, 18c, 19c (Unified Auditing)

select USER_NAME, ENABLED_OPT, SUCCESS, FAILURE from AUDIT_UNIFIED_ENABLED_POLICIES;

Oracle Database Enterprise Edition

(Fine Grained Auditing)

SELECT POLICY_NAME, ENABLED from DBA_AUDIT_POLICIES;

Oracle Database 11g(Standard Auditing)

IMPORTANT! Starting with version 9.96, Netwrix Auditor provides limited support of Oracle Database 11g and trail auditing mode accordingly. See Data Collection from Oracle Database for more information.

SELECT audit_option, success, failure FROM dba_stmt_audit_opts;

NOTE: To review your initialization parameters, execute the following command:

SHOW PARAMETERS audit%r;

NOTE: If you want to clean your audit settings periodically, refer to the following Oracle Help Center article for more information: Database PL/SQL Packages and Types Reference.

Go Up