September 21, 2009 at 6:55 am
Hallo
to comply local Goverment security regulations, I need to trace user operations on some databases, including accesses and simple SELECT statements and including administrators' ones.
I don't need to trace details on edited data, just the database and possibly the object(s) involved.
Is out there on the market any tool to trace such events? Or should I work it out by SQL Profiler or similar?
September 21, 2009 at 7:03 am
You could enable C2 auditing and process the trace file to persist the data you want to.
(have a look at BOL for its content)
Maybe even my little article "SQL Server and SOX" can get you started for this quest.
http://www.sqlservercentral.com/articles/Security/3203/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 21, 2009 at 7:32 am
A trace would be the best way to do this. C2 can add lots of overhead, but you'd have to determine if that is the scope of data you needed. If you needed less, set up a custom trace to do less.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply