Re: Audit trail

2006-08-21 Thread Peter Brawley
Chris >I would like to create an audit trail for one table in my DB.  Users will login to my >web site and be able to enter and edit information, I want to keep a record of what >changes are made by what user.  These users will be web site users and not actual >MySQL users.  Is there an eas

Re: Audit trail

2006-08-21 Thread Chris Knipe
Well MySQL will see all the changes coming from a single user (the user who the web site connects to the database as). You'll have to add your own routines to log that info to a table or something... Unless ofcourse, I'm missing something, which I doubt :) Regards, Chris. - Original Mes