Re: How to audit entire database?

[Saravanan K]

Hi,

I need to audit the inserted row & deleted row & updated row

if i change first_name (column)
it should show the tablename,column name,old value,new value,updated time in audit table.

if i have 54 tables in my database. Trigger should be fired for all the tables.

I need only one procedure & one trigger.


can single trigger be fired for all the tables in a database?

if i enter this following query,

insert into employee(id,first_name,last_name) values(1,'tom','peter');

how could you update the table name as 'employee' in audit table?


Could anyone?

Advance Thanks.



--Saravanan



Edited 1 time(s). Last edit at 08/05/2010 10:51PM by Saravanan K.