There are few ways to accomplish ur requirement,

1) Audit the DML actions
2) Write after trigger on the tables which requires auditing, and store the results in a table.