HElp please (Think I may be in over my head)
-
I have an database that was created in Access. I used the upsizing wizard to create a Access front end SQL back end application. Is there a way I can audit all the DML activity that occurs on the database. One of our security requirements is that I determine who and what was changed on the database in the system. I figured that I could use the upsizing wizard in Access and write some stored procedures to get the audit information. IS this possible or am I in over my head.
Thanks in Advance
_WM
-
You need to use triggers to do this. Create an audit table for each table you need to audit. Then create the trigger to insert into those tables and keep the datetime/who info at the same time.
-
To audit the data do as stated above and create some triggers. There is no real way to audit data model changes though other than putting triggers on the system tables (very bad idea). So, the best way to do that is to keep scripts for creating the data model in a source control application and then limit the permissions on who can modify the database.
Gary Johnson
Sr Database Engineer -
also check out in Books Online:
c2 audit mode Option
Setting Configuration Options
Auditing SQL Server Activity
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply