Daniel
Are you auditing data or auditing code? I have recently(and currently) am working on a system which implements for the pharmaceutical industry total data logging. Luckily i was able to do this from the start and implemented the following. 1) every table(on which there is logging-there are a couple of internals we don’t) have a mirror table. The creation of the mirror table is handled with SQL so i dont have to manually create it. The mirror table contains a copy of a record and everytime the record is changed gets a fresh copy of the record 2) a central(one table for the database) table contains a ‘header’ for records(not for the mirrors) wich records the data changed who changed etc etc. -this is ‘kicked off’ by the trigger on the table and created by a central process on the server side(so cant bypass it no matter how a record is saved). 3) As well as keeping an audit of changes the administrator can define tables that require changes to be QA’d and this forces the save of record to ask for a change reason and record ‘lock’ the record until the change is approved 4)every ‘input’ form has an ‘history’ page which shows all the dates of changes and allows the user to see which fields where changed and from what to what. 5)in additon to the above access control defines which users have access to edit tables/fields and who can verify(approve) changes If you are auditing code I have that in my system but then there are several recent sample systems of ways to achieve that. If any of that reflects anything that you are trying to achieve feel free to contact me off-list and i can give you some insight. Nigel Greenlee > On 6 Jan 2017, at 11:52, Daniel N. Solenthaler <[email protected]> wrote: > > Hi everyone, > > We are thinking about adding Audit Trails to our database. > > Found a very old Tech Note on the topic: > ftp://ftp.4d.com/ACI_TECHNICAL_NOTES/ACIDOC/CMU/CMU79933.HTM > > Are there any newer approaches or components available? > Has anyone done this? > > I don’t want to start off with a solution from 1998 and do not intend to > re-invent the wheel either. > > Any help appreciated! > > Thanks > Daniel > > -------------------------------------------------------- > Daniel Nestor Solenthaler > eMail: [email protected] > -------------------------------------------------------- > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
