- How much space do you have for logging and is the expense associated with it justifiable?
- How far back do you keep the logged data?
- Do you log queries of the logged data?
- Who has access to the logged data?
Insert Into audit
This means now I am storing the user and query with each row returned and I am doubling the reads on my database.
I certainly don't have the solution to this problem. I know that for Inserts/Updates/Deletes, I like triggers because they put all the code in one place and will fire on all changes unless someone explicitly disables triggers before making a change and if this happens you have other problems.
I'd be interested in hearing what other people think.