Hi,
I want to capture the column level changes of particular table.
Is there any way or workaround to access the old and new values for particular table as number of columns in a table can be more than 50 and we want to audit all the columns and I'm thinking of storing the audit of all the tables in one table.
Any help would be highly appreciated.
VARSHA
Can anyone help me to achieve this....
Vinish Kapoor
Using the database trigger, you can get the old and new values and it will be better if you will create the same table for audit purposes. You can some additional fields such as action_type, user, etc which will help in the audit.
Below is an example:
VARSHA
Thanks for the reply..
"it will be better if you will create the same table for audit purposes"
U mean separate audit table for each table, can't we store audit of all the tables in one table
Vinish Kapoor
Yes, use a separate audit table for each table.