- OracleApps Epicenter - http://www.oracleappshub.com -

Database Auditing

The Oracle database has sophisticated auditing capabilities and can audit virtually any action within the database. Oracle9i introduces Fine Grained Auditing which allows auditing down to the column level in queries. The Oracle database auditing features and Oracle Applications auditing features are completely separate mechanisms.

By default, only “Instance Startup”, “Instance Shutdown”, and connections to the database with administrator privileges are audited. Usually only session and database user auditing are enabled.

In the init.ora file, set the audit_trail parameter to true and restart the database.

From the SYSTEM user in SQL*Plus, execute the SQL AUDIT commands that coincide with your requirements.