Auditing: Trigger or Audit_Trail?

Hello all,

I'm spending a lot of time reading and studying, trying to decide whether to pursue auditing via the Audit Trail tables or via a trigger on the tables that I want to audit.

My question is this: if I have one schema that I would like to audit (131 tables and 196000 records, and not a fast growing db), and what I want to audit is DML (delete and update only) and who does it, when, and from where, am I better off using the Audit Trail or using triggers? If I use the Audit Trail can I change it so that it will do just what I want, or is this "not good to do"?

I've got lots of example code that I'm trying to follow to do this, I just need to know which is the better to do. Thanks so much!

-- 
Teresa Redmond
Programmer/Analyst III
Anteon Corporation
tredmond at anteon dot com