7 Sep
2016
7 Sep
'16
6:58 p.m.
All, Before I reinvent a wheel again, thought of checking with you experts whether any recommendation or suggestion for implementing audit trail feature for your database. I am looking for any open source product/tool for this purpose. I thought of exploring audit plugin, but I am not sure whether we can enable audit trail for the data changes in a tables. For example: *ORDER table:* ORDER_ID PRODUCT_ID QTY ORDER_DATE SHIP_DATE DELIVERY_DATE DELIVERY_ADDRESS Any changes on the above table's data (rows), we need to capture the audit trail like TABLE_NAME,COLUMN_NAME,OLD_VALUE,NEW_VALUE,CHANGE_DATE,CHANGE_BY,HOST,APP,MODULE etc. Thank you, Karthick