On Tue, Jan 10, 2017 at 9:53 PM, Dave Nasralla <[email protected]> wrote:
> Right. In one system people with high level access can request to see > a social security number of an employee. The system records who viewed > it, and the user must enter a "why" they are viewing it. > I was following the debate only lightly, so maybe this question was already discussed: do you keep complete audit trail in data file or export it to another system? I maintain two system that keep audit trail and the table with log records grows really fast - in one case (20+ workstations) most of the 10+GB data file consist of audit trail table, even when it deletes records older then 6 months. The deletion of log entries cancels the main benefit of audit trail and is a relict of the past, I could disable it and let the data grow, but maybe there are better way how to handle it (export to separate single user app?) -- Peter Bozek ********************************************************************** 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] **********************************************************************

