Configure and Administer Database Auditing

In my previous topic I have given an idea about basics of oracle database auditing. Before entering in this topic I assume that my previous topic “Basics of Database Auditing” has already been read. Actions Audited by Default Regardless of whether database auditing is enabled, Oracle Database always audits certain database-related operations and writes them [...]

Read Full Post »

Audit Trigger Activity in Oracle

Auditing a trigger activity or SQL inside trigger is no different than auditing normal SQL. In our business environment it was required to audit triggering event whenever the SQL statement inside trigger does unsucessful execution. We can achive our goal by simply audit the SQL for which trigger fires. Additionally you may also wish to [...]

Read Full Post »

How to move audit table out of SYSTEM tablespace

Oracle strongly recommended to use the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION provided with the DBMS_MGMT package in order to move audit trail table out of SYSTEM tablespace. But the procedure SET_AUDIT_TRAIL_LOCATION by default is not available until 11g. It is available in 11g. However with manual script you can move SYS.AUD$ table out of SYSTEM tablespace. But you need [...]

Read Full Post »