The interactions in this eCourse require Javascript to be enabled.
Auditing by Using a Trigger: Part 2
previous|next
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. Watch Sheila use the Object Browser to create a trigger that performs the audit functionality. Also, watch Sheila use the SQL workshop tool to test the performance of the trigger.