Walter Meester
HoogkarspelNetherlands
>Hi,
>
>I was wondering what others here think about storing changes to every record into some kind of audit trail table? Is this a good and reasonable design or waste of database storage?
>
>TIA.
Hi Dmitry.
As others have mentioned, it depends on your requirements. But with an audittrail, you have powerfull means to:
1. To see who did change what record at what time
2. Undo a change
3. Travel back in time and recontruct the data at some point in time
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only