Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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.
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!"
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.