I need to trace the user log against my database tables.
Most of the tables have the customer’s sensitive data.
I need save every action (select , insert, update and delete) against those tables information with user log to AuditLog table.
For example,
If a user viewed or insert or update or delete the SocialSecurityNumber from customer table,
I need to enter the above actions with user information to AuditLog table.
Can anyone help me on this...
Thanks in advance,
Nithi