Hi,
I want to make one audit table to maintain logs of all the tables which are present in my schema. If i do any DML operation on any table inside database then it will be log into that single audit table.
I can maintain a log table for every table individually.but i don't want to maintain separate log table for every table. I want sing log table for all the tables.
Table contains : username or userid,table_name,date,time,old value,new value.
Please provide a solutions asap.
Regards,
Somdutt Harihar