joybanerjee

 Profile Answers by joybanerjee Questions by joybanerjee

• Dec 3rd, 2007

 

you can write  an  after insert  trigger  to  maintain the audit  of  that table.

MaheshRamekar

 Profile Answers by MaheshRamekar 

• Jun 10th, 2009

 

Using Log miner

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Jun 11th, 2009

 

Most simple way is to write an Insert trigger on the table which you want to get audited.

girish1983

 Profile Answers by girish1983 

• May 5th, 2010

 

Here, we can enable the auditing on Database level.
As such we come to know which user has done what tasks and on which objects and at what time.
But for it DB has to be put in auditing mode.