I need to create an Audit table such that when users delete or modify records, the time of change, the deleted item (or the old and the new value) for a record change is entered into the Audit table.I also need to capture who made the changes.
Can anyone give me ideas on how to implement this. Thanks.