Creating a Trigger for Auditing
Sheila and Don work on creating a trigger that captures the date, time, user, employee ID, old salary, and new salary when the salary column is changed.
In the module "Working with Database Objects," you watched Sheila create the AUDIT_RECORD_TB1 table. Now that Sheila has the audit table, she can create an audit system.
Help Sheila create a trigger that performs the audit functionality and test the performance of the trigger.
 |
