Thanks for the help. This resolved my problem

Paul,

I am aware that it can be done using trigger, but dont know how to write a trigger as I have never done it before and I am weak in...

We have vendor softwares to access the tables. I want to store the insert, update and delete events in a different table, so that they can be reviewed later.