Re: Audit Trail?

lester@access.digex.net (Lester Knutsen) wrote: Unfortunately, I'm using a v7.11 engine. I say unfortunately, because the process you describe in your article is exactly what I was looking for. The Trusted Facility does not seem to offer the same capability, at least in my reading of the manual. The audit trail produced will tell me that a row was added, altered, or deleted, but not what the contents of the row were. Did Informix really downgrade the capabilities of the engine in this regard or is there something that I'm overlooking? I really appreciate the suggestion and hope to find some good news somewhere. Still hopeful, M. Livenspargar >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 # >#############################################################################