Thursday, March 25, 2010

Auditing database users..

We have enabled auditing for database users (ERP) with below parameters.

- AUDIT_TRAIL = 'db, extended'
- AUDIT ALL BY erp BY ACCESS
- Audit update table, delete table, insert table by erp by access;

DB users batch file, which is scheduled. check below post for batch file.
http://rakeshocp.blogspot.com/2010/03/dbusersbat.html

No comments: