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
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to