Hi
Lets say I have a table MyUser (column: MyuserID, Username)
Another table Product (column: ProductID, ProductName)
Then I created a table MyUser_Audit (column: MyUserID, Username, audit_action, Audit_Timestamp ) to store all the audit trail.
And now, user01 with name Mary inserted ProductID and ProductName into the Product table.
How do I create a trigger to audit trail...