Information Technology Reference
In-Depth Information
Automated tracking of changes to tables for audit purposes using history tables and database triggers
41
Fig 45: Database triggers for audit history tables
41
Strictly speaking, user records are not usually deleted when a user leaves the organisation, but merely
marked deleted
(i.e., an update). The example
above illustrates the generic mechanism which may be useful for other tables.