What the audit database? What is the basis of audit data and how to use it. Are the benefits in using a database audit ...??
Database auditing is used for three things:
1. Monitoring of resource bottlenecks
Certain criteria such as the speed of queries are returned can be correlated to see at peak occur, and sometimes you can see broken queries this way.
2. Tracking errors
Auditing can be enabled on most systems to alert you when critical errors occur. Critical errors can be things such as database corruption, a person dropping a table or a file lock is stuck on a ridiculous amount of time.
3. Security
The security audit includes persons who read / write operations that are outside the paramaters of the application (as if the application does not write a single line at a time in each table, and writes at 50 you can have the declaration marked), you can also logins successfully audited and have failed. It's amazing how many developers choose to connect to an application userid / password to do a job database, and sometimes there are problems, and no ass up.
Posted on February 23, 2010.
