Re: Audit Trail

Posted in 1994

Storm Software — 12 Dec 1994 14:48:17 GMT — source: Informix-list mailing list archive (1991-1998)

Anne Harris (anne@ULTRIX) wrote: : I would like to get a report of the changes to the database : for the day. The audit trail puts out a data file. Is there : someway of reading this file. Try a trigger on the tables you are interested in executing a stored procedure which in turn writes to an audit trail table with the new and the old record. This way you only need an audit trail on the tables you are interested in. Watch out for uploads to a trigger-marked table. Suddenly, big audit trails!