Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Hi John,
Although i haven't done it myeslf, if you use cursoradapter, you could probably use the beforeupdate and beforedelete event to write audit trail, which is at the application level data access layer.
David
----------------------------------------
Is there a good way to track changes to records in a table for auditing purposes? I would like to automatically add a log in a table when a user either edits or deletes a record for data auditing purposes. It should log values of old data and UserID of the user performing the action.
Is this something that I need to setup at the "application" level (probably at the data access layer) instead of at the "database" level?
It's "my" world. You're just living in it.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement