Re: Table auditing

Posted in 1994

Mike Aubury — Mon, 14 Nov 1994 13:25:59 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <jolomoCz0I6A.Loo@netcom.com> jolomo@netcom.com "Joe Morris" writes: > Hi, if a certain row is updated in a table I want to know who did > it. Rather than writing a program to do this, I'm trying to use > auditing on the table. Unfortunately the log file generated is > binary, but by using "strings" on it I can see that it stores the > user-id. Has anyone developed a tool to analyse the data in > this file or can someone tell me the layout of this file? > > I'm using Informix4GL 4.00 > > Thanks > -- > -joe "Honey, they're in *everybody's* eggs" --firesigns > We have a product called "MONITOR" which does exactly that. It allows you to analyse the audit trails to recover ALL information (not just strings !!!) and even be used to produce customised reports/screens (eg. statistical info). The information is stored in an informix table so you can use SQL or 4GL to analyse the data. Mail me if you want more details. Mike Aubury