Go Up
You are here: DeploymentConfigure 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 11g(Standard Auditing)

SELECT audit_option, success, failure FROM dba_stmt_audit_opts;

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

SHOW PARAMETERS audit%r;

Oracle Database 12c (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;

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