April 27, 2005 at 10:10 am
We're setting up a new time/attendance program that will integrate with our payroll system. I know that I can create a trigger to audit any updates, but our hr mgr also wants to be able to track anyone that views(select) specific columns in a select few tables. Can anyone point in the right direction for info on the 'best' way to set this up? Any assistance greatly appreciated.
TIA,
L
April 27, 2005 at 11:28 am
You either have to set a trace on the server which can cause a lot of overhead...
Or you can make sure that the users can only access the data from stored procs and code the audit process from within those stored procs.
April 27, 2005 at 11:45 am
The problem is that they have access through an app that requires certain permissions I'm not allowed to change. The app has already been purchased (prior to my being in this position) and they didn't have any SQL person, let alone someone to review it. I was hoping to avoid a trace if possible.
l
April 27, 2005 at 11:51 am
I'll leave this one in the hands of the gurus... I don't know any other ways.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply