Re: Q:Auditing Infx 7.1OnLine, To capture sequence of transactions.

Rajiv Goyal wrote: > > I was wondering how informix supports Auditing, on the 7.1 OnLine server. > Looking at the manuals gave me very little information. I had extensively > used Audit trails in Ingres. I hope Informix has something similar too. > > The real problem: I have a huge software system that accesses Informix 7.1 > Online. > I am required to build a chart of, How each program accesses the DB tables > (Ins, upd..etc) and what tables does it access. Well the first thing to do is define the difference between secure auditing and audit trails. Secure Auditing This is the recording of events, such as when someone inserts a record. The key here is to realise that you audit ALL inserted records. Auditing is switched on at system level with default masks to define which events are audited. Each event can be audited for success, failure or both. Each user can also have a mask defined. Audit Trails This is the recording of changes to data in a table. These are best implemented as triggers, with stored procedures doing any processing required. If you wanted to audit changes to records in a table, you would define an update trigger on that table. The trigger could then send the 'old' and 'new' versions of the record to a stored procedure for analysis and logging. The great thing about triggers is that it doesn't matter what front-end you use to update a table. It sounds to me as though you need audit trails, which is the norm IME. I hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+