how to implement Audit for SQL server 6.5 & 7.0

Question

Post reply

how to implement Audit for SQL server 6.5 & 7.0

CADDIS

Newbie

Points: 3
More actions
December 18, 2003 at 5:20 am

#65361

Hi friends, anybody can tell me where I could find documentation to do this procedure ? sorry for the basic-nature of my question but I don´t know much about SQL, my expertise is Infrastructure and OS.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114562 More actions · Answer 1

What are you trying to audit? Just logins? Queries as well? Changes in data?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

CADDIS Newbie Points: 3 More actions · Answer 2

thank you for your reply,

I need to audit anything that you mention

Logins, Queries and changes

thank you again

K. Brian Kelley SSC Guru Points: 114562 More actions · Answer 3

All of this is SQL 7.0, someone else will have to comment on SQL 6.5 as I no longer have the docs or a working install.

Look at Books Online for the trace stored procedures. You can get used to what these will do by using Profiler. This will allow you to audit queries.

To audit logins, you can set SQL Server to record login failures (and successes if you want). In EM, right-click on your SQL Server and choose properties. Then click on the Security tab. Set the audit value you want, then stop and restart SQL Server. It should write the audit records in the Application Event Log for the system.

For changes in data, you'll probably need to look at putting triggers on table (in order to record before and after). There are 3rd party products that can do this for you.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley