Question:
Hi,
I would like to know how, through triggers in the Bank, I can in addition to save the operations performed and in which table performed also the user logged in the system (not the database user, if the system user) at the time of the change.
In this case I would have: [Users table] [Products table] [Log table]
Any changes made to the users or products table should generate a row in the log table, with:
date, operation (I,U,D), table, user(user table), modified record id.
I appreciate the feedback.
Answer:
For triggers from what I know you would have to create one for each table. depending on the system, you'd better do some method so that every execution in a database sends the record to the LOG table