My database has a 'LastModifiedUser' column on every table in which I intend to collect the logged in user from an application who makes a change. I am not talking about the database user so essentially this is just a string on each entity. I would like to find a way to default this for each entity so that other developers don't have t...
Hi, I'm looking for a way of making simple event log for my tables. I have few tables that can be changed by various users, and I want to keep track on: - who made the change - when - what was before update - what is the new value - which table and which record & column somthing like will be great: 20:00:00 | john | update | produc...
I'm currently using an SqlDataSource in ASP.NET/C# to let users insert, delete and update entries in a table/gridview. Every event needs to be written to an audit table. I have easily implemented inserting and deleting - when inserting, the main info audited is just the parameter values of the insert query (e.Command.Parameters[0].Value...
I require all changes such as inserts, updates and deletes to a table to be auditted, and I'm using a simple SQLDataSource and GridView with automagically generated INSERT/UPDATE/DELETE statements. Problem is, when a row is updated I want to get the ID (primary key) and put that into the auditting table - but because the only parameters ...
Doctrine 1.x and 2 both offer some kind of Versionable support in the form of a separate auditing table that tracks changes over time. However, the versions appear to be intended for per-row use (ie, they all maintain their own version number) instead of database-wide, such as in Hibernate Envers, which gives every row a unique revision ...