question

Edgar Morrobert avatar image
Edgar Morrobert asked

SQL Audit Program

Hello, I`m a System Auditor looking for an audit program to SQL. I´ll apreciate any help.

sqlauditprogramming
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image
DaniSQL answered

Checkout this tool from Apex. Also take a look at this page about SQL Server auditing tool reviews.

Good Luck!

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rpearsondev avatar image
rpearsondev answered
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/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RichardJenson avatar image
RichardJenson answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.