Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003

    Unanswered: Table Design Question - Creating Audit Trails

    I would like to hear if it is a common table design practice to track the names of the users who modify data along with the dates of the modifications. Several years ago I worked at a company that, for most tables, tracked the following information.

    Create User - User Id of person who created the record
    Create Date - Date and time of record creation
    Modify User - User Id of person who modified the record
    Modify Date - Date and time of record modification

    Is this a common practice?

    Thanks, Dave

  2. #2
    Join Date
    Aug 2002
    Would it be possible to deploy third party tools like Lumigent's ENTEGRA which is suitable for such Auditing.
    --Satya SKJ
    Microsoft SQL Server MVP

  3. #3
    Join Date
    Jan 2003
    Pittsburgh, PA

    Thumbs up Re: Table Design Question - Creating Audit Trails

    Yes, that would be a common practice. There are other methods of tracking changes: specific software that tracks the changes or audit tables that record the changes, but your method is very common.

    It can be important for several reasons, two of which are security (knowing who changed data and when), and timeliness of data (when was the last time the data was updated, and does it need to be revisited). There are other reasons too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts