SQL Server Audit Trail Generation
Instantly start auditing any data change made from any application in any SQL Server database. No software changes.
OmniAudit installs complete data change auditing in your SQL Server database in just a
few minutes. Audit every field in every table, or pick and choose the tables and fields you
want to audit. Either way OmniAudit does the hard work of creating the necessary audit trail
objects in your database with a click of a button.
How Does OmniAudit Help You Build SQL Server Audit Trails?
An OmniAudit audit trail tells you:
• the table and field that was changed
• before and after values
• the user making the change
• the date and time they changed it
• the workstation used
• the application used
- No SQL programming required. OmniAudit automatically builds all the necessary database objects.
- Auditing occurs regardless of application. Whether a commerical software package, an in-house
application, even Microsoft tools such as SQL Management Studio, Query Analyzer, or Microsoft Access.
Existing software is not required to be changed for auditing.
- You choose what to audit Audit every field in your database, just a few fields in a single table,
or anything in between.
- Easy to use. Regardless of your database skill level, if you can connect to the database server
(and have the appropriate permissions), you can add a complete, fully-functional audit trail solution to
any SQL Server database.
- Fully accessible audit data. Collected audit data is stored in conventional SQL Server tables,
which can be referenced by any SQL Server reporting tool (such as Reporting Services, Crystal Reports, etc.)
- Flexible. Change your auditing selections at any time and with one click
of a button, OmniAudit automatically updates all affected tables without impacting your
existing audit trail data.
Use OmniAudit as Part of Your Compliance Requirements
Audit trails are an important–sometimes required–part of database administration.
Many systems which maintain critical information benefit from audit trails. Often government
regulations such as Sarbanes-Oxley, FDA Part 11, PCI-CISP, and HIPAA require audit trails on electronic records.
Improve Your Own Database Development Processes
Audit trails also are tremendously useful for internal quality
assurance. Any organization which develops database software–whether strictly
for in-house use or as commerical products–can greatly streamline debugging and testing with
an audit trail showing the net effect of how a software function changes the database. Nothing beats
an audit trail for highlighting unintended side-effects either.