Logging user views to a record on the AS/400
60 pts.
0
Q:
Logging user views to a record on the AS/400
Is there a way on the As/400 to know every time a user accesses a specific record?  I need to know when a user even looks at a record.  I know I can use journaling to record changes to a record as well as adding and deleting records, but as far as I know, journaling will not record when a user just views a record.  I could also change the programs to record when users view a record in the application, but this would not record views via SQL and other tools outside the application.  Is it even possible to record data access at this level?



Software/Hardware used:
AS/400
ASKED: Nov 4 2009  8:59 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
4885 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
Defining a read trigger using ADDPFTRG should do the trick. The trigger will be called for every record read from the file and then the trigger can just log those reads to the record of interest.

Bruce Vining
Bruce Vining Services
----------------------------------------------------------------------

You cannot get it at the record level, but you can get it at the file level.
use OMTJRNE ( *NONE) on your STRJRNPF command.
That being said, if there are selective fields in the file that you do not want people to access, you can change the authority on th PF so they cannot get at it. Then create a LF with only selected fields from the file and authorize them to the LF.
Last Answered: Nov 5 2009  2:47 PM GMT by Bvining   4885 pts.
Latest Contributors: CharlieBrowne   6540 pts., Teandy   3250 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0