RE: Security Trail

Hi Bart

There are two obvious ways that this can be achieved:

1.  If the file(s) is journalled you could interrogate the journal
entries for the file (or files) that contain the field you want to
audit.  The journal can contain the data value both before and after the
field was updated but this is depending on how the journal is set up.
Also, the image in the journal contains all the data (all fields plus
other such data such who and when the file was updated) from the file,
so you would need to know the position of the field within the file to
find the journal image.

2.  Another and perhaps more straight forward option is to use triggers.
You can attach triggers to a file (ADDPFTRG) that in essence will call a
user defined program every time the file is updated.  The user defined
program will receive the record from the file that was changed and again
this data can be interrogated to determine the value of the field you
would like to monitor.

I hope this is of help.

Best regards

Jacob Christiansen
Executive Director


Technocrats Computer Services Limited
Telephone:  +44 (0) 207 929 0007
Fax:            +44 (0) 207 929 0008
E-mail:         mailto:christiansenj@technocrats.co.uk
Web:            http://www.technocrats.co.uk

************************************************************************
*********************
The information in this email is confidential and is intended solely for
the addressee and may contain information which is privileged and
confidential.  Access to this email by anyone else is unauthorised. If
you are not the intended recipient, you must not read, use, copy or
disseminate the information and you should contact Technocrats Computer
Services Ltd, so that we can take the appropriate action at no cost to
yourself.

Technocrats Computer Services Ltd, Walbrook House, 23 - 29 Walbrook,
London EC4N 8BT, England. 
Email: Administration@technocrats.co.uk. Telephone: +44 (0)207 929 0007.
Fax: +44 (0)207 929 0008.  
************************************************************************
*********************





-----Original Message-----
From: Bart [mailto:Bart.Verweijen@advalvas.be]
Sent: 06 June 2000 08:45
To: midrange-l@midrange.com
Subject: Security Trail


Hi,

We want to follow the data in a certain field of a file (suppliers bank
account number). Is there a way to implement some kind of audit trail on
system level; so everytime someone changes that field, a log gets
updated
with userdata and the change ?

Thanks for the help,
Bart Verweijen
Anco

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---