I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I've got a question about something Steve brought up, but I didn't want to ask it in response to the editorial, as I thought my question was too far off topic.
In my current job, I've seen the practice of logging (auditing) users activity to a much higher degree, than I did at my old job. And I think my current employer and colleagues are doing a much better job on this, than I did at my old job. Kudos to them!!
Their practice is to add four columns to every table: CreatedBy, CreatedOn, UpdatedBy and UpdatedOn. (They might not do this for lookup tables, but every other table has those four columns.) But Steve seems to favor using a separate logging/audit table, to having those four columns in each table. What I'd like to ask is this, is using a separate log/audit table a better practice? Or is it just a preference?
Kindest Regards, Rod Connect with me on LinkedIn.