This article describes how to use triggers to create audit trails, using two scenarios:
1) A separate audit table is created for each table to be audited
2) A single audit table audits all tables
http://www.nigelrivett.net/Triggers_2_Creating_Audit_Trails.html