Hello, I`m a System Auditor looking for an audit program to SQL. I´ll apreciate any help.
asked
SQL Audit Program
SQL Server 2008 offers a tool called SQL Server Audit. It basically uses extended events to track what happens on the server. You have a degree of control over it. Here is a good place to start reading about it.
Permissions audit?
Access audit?
I have created an access/ logon audit based on logon triggers. Example http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/
To audit permissions, I recommend you check out this article. http://jasonbrimhall.info/?p=391
If you are looking to audit data rather than server events then you could try [SQL Table Audit][1]. Otherwise I would suggest SQL Sever Audit. [1]:
http://renholdsoftware.com/SQLTableAudit/
Hi, To perform a quick and easy auditing of the SQL Server, you can try in a utility tool named LepideAuditor for SQL Server which I have tested and is able to do such audit tasks easily. This tool audits both server and database objects and can report on what, when, who and where for all the changes done in it. Whether you are making the changes in the tables or the stored procedures in the database, it will generate report for all these changes done.
2 People are following this question.
