List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:August 21 2006 7:07pm
Subject:Re: Audit trail
View as plain text  
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 :)


----- Original Message ----- 
From: "Chris W" <2wsxdr5@stripped>
To: "MYSQL General List" <mysql@stripped>
Sent: Monday, August 21, 2006 9:02 PM
Subject: Audit trail

>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 easy method in 
>MySQL to do this, or do I just need to write code to track any changes as 
>they are entered?
> -- 
> Chris W
> Gift Giving Made Easy
> Get the gifts you want & give the gifts they want
> One stop wish list for any gift, from anywhere, for any occasion!
> -- 
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

Audit trailChris W21 Aug
  • Re: Audit trailChris Knipe21 Aug
  • Re: Audit trailPeter Brawley21 Aug