Why do we need to add columns to the audited tables

Jul 13, 2011 at 8:43 PM

Why do we add those columns on each audited tables?

Created
CreatedBy
Modified
ModifiedBy
RowVersion

We can have all this information from the Audit table.  Am I missing something?

Jan 17, 2014 at 8:51 AM
The user won't be able to supply his information about user name if he wants to, because all he's doing is inserting a row into table, for example. If there is no row for user name (for example, if it is web application, which uses single DB user account), there will be no way to know who exactly is modifying the table.