Oninit cdi / Archive
Talk to an expert →

audit trail suggestion?

Posted in 2001

Topics: Security, Permissions & Auditing

Rafael Padilla — — source: Informix-list mailing list archive (1991-1998)

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/

↪ replying to Rafael Padilla
Randy Reiter — — source: Informix-list mailing list archive (1991-1998)

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/

↪ replying to Randy Reiter
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

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/ > >

↪ replying to Rafael Padilla
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

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/

↪ replying to Rafael Padilla
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)

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!"