Re: Audit Trail?

Hi, Since you did not say which version and what Informix product its hard to give details but here are a few possibilities. Informix SE - all versions have audits that can be started and stoped. See the create audit command in the SQL manual. I did an articule on coverting these to human-readable format that is available on our user group web page (http://www.access.digex/~waiug). With Informix Online versions 7+ you need to see the Trusted Facility Manual for information on audit trails. This is also available with Online/Secure 5.0. but most people don't have the Secure version of 5.0. These should be able to handle all of your requirements. If you have Online 5.X, this may be a good reason to upgrade. Regards - Lester > M. Livenspargar asked: > Our application requires us to keep a human-readable audit trail of > every modification to our database (the Informix version doesn't exist > yet -- we're converting from isam files). So far the only thing we > know to do is to put insert, update, and delete triggers on every > table in the database to log each change. > <Stuff deleted> > Surely we're not the only site that requires such accounting. Has > anybody else come up with something better, or is there something in > the engine itself that we have overlooked? > ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################