root@charlie.OZ (Just call me SUPER) (12/01/88)
We are developing a Unify/Accell based application for the
payroll system here at the University. A requirement of this
system is to provide audit trail facilities for data entry,
internal auditor's, etc.. Has anyone any experience in this
area to offer suggestions/solutions.
Wayne Jennings.
--
Computer Services,
DEAKIN UNIVERSITY, Victoria, 3217, AUSTRALIA.
VOICE: (052) 471 161 (International: +61 52 471 161)
UUCP: {seismo,mcvax,ukc,ubc-vision}!munnari!charlie.oz!wayne (fast)
ARPA: munnari!charlie.oz!wayne@seismo.ARPAhonzo@4gl.UUCP (Honzo Svasek) (12/03/88)
From article <7222@charlie.OZ>, by root@charlie.OZ (Just call me SUPER): > We are developing a Unify/Accell based application for the > payroll system here at the University. A requirement of this > system is to provide audit trail facilities for data entry, > internal auditor's, etc.. Has anyone any experience in this > area to offer suggestions/solutions. We have developed a utility that reads the Unify transactie log file and converts it into ASCII. As it also translates the 'field numbers' into field names, so it is not effected by database configurations. It produces records like: <date/time> <pid> <transaction> <user> <table_name.field_name> DATA DATA is either the data in ascii format, or the keyword DELETED It is doable this way, and you dont have to include code in your ACCELL scripts. And you also log 'add hoc' updates done with SQL, and even catch C programs using Host Language Interface. The only problem is that it is a commercial product and I cannot post it. A source licence is not that expensive though, please mail me for more info. I_I( _ I I ) Honzo Svasek <honzo@4gl.nl> --------------------------------------------------- Svasek Software Consultants IJsselkade 24, 3401 RC IJsselstein, the Netherlands ---------------------------------------------------
allbery@ncoast.UUCP (Brandon S. Allbery) (12/11/88)
As quoted from <560@4gl.UUCP> by honzo@4gl.UUCP (Honzo Svasek): +--------------- | From article <7222@charlie.OZ>, by root@charlie.OZ (Just call me SUPER): | > We are developing a Unify/Accell based application for the | > payroll system here at the University. A requirement of this | > system is to provide audit trail facilities for data entry, | > internal auditor's, etc.. Has anyone any experience in this | > area to offer suggestions/solutions. | | We have developed a utility that reads the Unify transactie log file | and converts it into ASCII. As it also translates the 'field numbers' | into field names, so it is not effected by database configurations. | | The only problem is that it is a commercial product and I cannot post it. | A source licence is not that expensive though, please mail me for more info. +--------------- May I suggest that this is rather trivial, given the information in the RDBMS HLI manual (the blue one, if they use the same color conventions everywhere)? Check the chapter on transaction logging and the function reference for opentj() et alia. ++Brandon -- Brandon S. Allbery, comp.sources.misc moderator and one admin of ncoast PA UN*X uunet!hal.cwru.edu!ncoast!allbery <PREFERRED!> ncoast!allbery@hal.cwru.edu allberyb@skybridge.sdi.cwru.edu <ALSO> allbery@uunet.uu.net comp.sources.misc is moving off ncoast -- please do NOT send submissions direct Send comp.sources.misc submissions to comp-sources-misc@<backbone>.