x

SQL Audit Program

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

more ▼

asked Apr 05, 2010 at 10:44 AM in Default

Edgar Morrobert gravatar image

Edgar Morrobert
21 1 1 1

(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

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.

more ▼

answered Apr 05, 2010 at 11:15 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98.5k 19 21 74

(comments are locked)
10|1200 characters needed characters left

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

Good Luck!

more ▼

answered Apr 05, 2010 at 10:53 AM

DaniSQL gravatar image

DaniSQL
4.9k 33 35 39

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Apr 05, 2010 at 04:58 PM

CirqueDeSQLeil gravatar image

CirqueDeSQLeil
4k 10 11 15

(comments are locked)
10|1200 characters needed characters left

If you are looking to audit data rather than server events then you could try SQL Table Audit. Otherwise I would suggest SQL Sever Audit.

more ▼

answered Oct 23, 2012 at 08:19 PM

rpearsondev gravatar image

rpearsondev
0

(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Apr 15, 2013 at 02:37 PM

RichardJenson gravatar image

RichardJenson
0

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x715
x43
x20

asked: Apr 05, 2010 at 10:44 AM

Seen: 2819 times

Last Updated: Apr 15, 2013 at 02:37 PM