Ramin Hossaini (blog)

Basic Auditing in Oracle

To check if auditing is enabled:

SHOW parameter AUDIT;

To enable auditing, modify/add the following in your PFILE and restart the database:

audit_trail = db;

To audit SELECTs on an object:

AUDIT SELECT ON object;

To list all Audit data on a database:

SELECT * FROM sys.aud$;

Purge/delete entries from the audit table:

DELETE FROM sys.aud$;

To view audit data:

SELECT * FROM sys.aud$;

To disable auditing:

NOAUDIT SELECT ANY TABLE;

Related posts:

1. Oracle: Basic user-logon auditing
2. Oracle: List all database-links
3. Oracle: Recovering a Tablespace
4. Listing key Oracle Database files
5. Turning Archive-log mode on and off