Re: SYSTEM21 Digest, Vol 10, Issue 6

You could also consider journaling those files of interest. A bit of an
overhead but may be worth it if it is important. 

Jim. 


-----Original Message-----
From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]
On Behalf Of Deon A von Blerk
Sent: Friday, January 27, 2012 11:27 AM
To: system21-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: Re: [SYSTEM21] SYSTEM21 Digest, Vol 10, Issue 6

I agree with Geoff. Added to that is the fact that many of the S21 files
have no audit e.g. INP15.

Regards

Kit
www.ecofitonline.com


> ----------------------------------------------------------------------
> 
> message: 1
> date: Fri, 27 Jan 2012 00:01:04 +0000
> from: Geoff Boreland <[email protected]>
> subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch
> 	Note
> 
> You might also want to contemplate the use of database triggers to 
> ensure you capture all the information required.
> 
> A typical audit file is only ever going to be as useful as all of the 
> programs that write / update it.  As soon as someone performs a write 
> or an update to the master file without including the audit file, then 
> the audit trail is compromised.
> 
> We have found that installing database triggers will ensure you 
> capture all database I/O's including SQL / DFU style updates, as the 
> I/O is performed at the operating system level and not within the program.
> 
> Regards
> Geoff

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list To post a message email:
SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives at
http://archive.midrange.com/system21.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.