RE:dentifying who deleted records - trigger programs

Blake,
You should be able to retrieve the user by doing something like:

D USERID S 10 INZ(*USER)

Then write the variable USERID to your file.

Here is an article I found on how to tell what program caused your
trigger to fire.

http://www.tylogix.com/Articles/TriggerTechniques.htm#Trigger_Firing_Pro
gram


I am curious about something though. I am assuming that you will be
writing this information to a file. Won't you run into the same storage
problems with the file that you would with a journal? I know you said
that this would be for deleted records, but don't the auditors want to
know about any change to a record? We are a privately held company so I
know very little about sox requirements.



Terry Anderson
Programming Manager
Citation Corporation
Switchboard 1.251.867.5481 ext 212
Direct Line 1.251.809.2312
Fax 251.867.0525
Cell 1.251.363.4975

message: 2
date: Thu, 13 Nov 2008 09:35:54 -0500
from: Blake.Moorcroft@xxxxxxxxxx
subject: RE: Identifying who deleted records - trigger programs

The use of the journals for data retrieval is being
investigated by another developer. However, there are
considerations about how long the data in the journals is
available due to the volume of data being processed. The
auditors are looking for control over one file and
governmental regs require stored data to be *immediately*
available for a period of no less than 7 years (and
displeasing a government auditor who can yank your operating
license immediately is not conducive to business operations).
The journals that would encompass this file also contain
record changes on close to 90 other files. While it would
be a preferred option, it may not be a viable option.

So, to cover the bases, I'm assigned to check the option of
triggers, which leads back to the original question of user
and program identification from inside a trigger event.

Have a good day.


Blake Moorcroft
Developer - Corporate
Russell A. Farrow Limited
1980 Ambassador Drive, PO Box 333, Windsor, Ontario N9C 3R4
Bus: 519-966-3003 ext. 566, Fax: 519-966-9870
blake.moorcroft@xxxxxxxxxx