Database logging offers a possibility to track changes that all users make to specific tables. This covers the scenario when a company needs to have control over changes that are made to critical data, however it does not cover the scenario when a company needs to have control over changes that are made by critical users. For example, there is a regulatory requirement for pharmaceutical companies to record an audit trail for user with admin privileges. To cover this scenario we would need to be able to track changes that specific users make to all tables.
Comments
Audit trail of data changes on select tables with added userid attribute loged for selected/crucial tables is now days a must.
Negative effect on transaction troughput and increasing of transaction duration would be minimized if such solution is done in FO framework as burst of inserts in chuncks or at the end of db transaction.
Category: Organization administration