audit trail suggestion?
Rafael Padilla asked how to audit who inserts, updates and deletes records, with a Delphi client. Randy Reiter promoted a commercial SQL monitor product; Obnoxio The Clown told the poster not to use it. Art S. Kagel said triggers work if the update load is not too great. Jonathan Leffler said CREATE AUDIT works well on SE. No single agreed solution.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, I'm looking for an advice in order to implement an audit trail in INFORMIX. We want to audit who inserts, updates and deletes records in a database. We want to know operation date, user name, table name and record which is afected. Like a reference we are using DELPHI like a Client Interface. Thank's for your help! Sent via Deja.com http://www.deja.com/
Refer to the Zero Impact Sql Monitor product line at www.sqlpower.com for SQL performance, end-user service level, Top N SQL, and data usage analysis. The product line will accomplish your objectives with no performance impact upon the database server. Regards, Randy Reiter Sql Power Tools 702.990.3209 www.sqlpower.com Rafael Padilla <rafaelpadilla@my-deja.com> wrote in message news:9617ak$6lg$1@nnrp1.deja.com... > Hi, > I'm looking for an advice in order to implement an audit trail in > INFORMIX. > > We want to audit who inserts, updates and deletes records in a database. > > We want to know operation date, user name, table name and record which > is afected. > > Like a reference we are using DELPHI like a Client Interface. > > Thank's for your help! > > > Sent via Deja.com > http://www.deja.com/
No, don't. It's a load of old cobblers. In the year of Our Lord Sun, 11 Feb 2001 15:51:19 -0500, "Horny Scribe" <rreiter@sqlslower.com> spake, saying: >Refer to the Zero Value Sql Monitor product line at www.sqlslower.com >for SQL performance, end-user service level, Top N SQL, and data usage >analysis. The product line will accomplish your objectives with no >performance impact upon the database server. > >Regards, > >Horny Scribe > >Sql Slower Tools > >www.sqlslower.com > >Rafael Padilla <rafaelpadilla@my-deja.com> wrote in message >news:9617ak$6lg$1@nnrp1.deja.com... >> Hi, >> I'm looking for an advice in order to implement an audit trail in >> INFORMIX. >> >> We want to audit who inserts, updates and deletes records in a database. >> >> We want to know operation date, user name, table name and record which >> is afected. >> >> Like a reference we are using DELPHI like a Client Interface. >> >> Thank's for your help! >> >> >> Sent via Deja.com >> http://www.deja.com/ > >
Triggers work if the update load is not too great. Art S. Kagel Rafael Padilla wrote: > > Hi, > I'm looking for an advice in order to implement an audit trail in > INFORMIX. > > We want to audit who inserts, updates and deletes records in a database. > > We want to know operation date, user name, table name and record which > is afected. > > Like a reference we are using DELPHI like a Client Interface. > > Thank's for your help! > > Sent via Deja.com > http://www.deja.com/
Rafael Padilla wrote: > I'm looking for an advice in order to implement an audit trail in > INFORMIX. > > We want to audit who inserts, updates and deletes records in a database. > > We want to know operation date, user name, table name and record which > is afected. > > Like a reference we are using DELPHI like a Client Interface. If you're using SE, CREATE AUDIT for a specific table works quite nicely. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"