Web lists-archives.com

audit trails

Good day all

   I am hoping this mail finds all well...

    I am in need of some assistance please.

    We have a few tables that I need to add auditing information for.

     The idea is that we need to create an audit table that will track
the following on the main table :

       - any changes (updates,deletes, inserts) to the main table

      The audit table should include the following information:

         -- Who made the changes (username logged in)
         -- What type of change (insert,update,delete)
         -- Date of change including time.
         -- if update, which fields were updated.
         -- Query that was run.

        I have tried to get similar examples on the net, however no
luck so far that gives the specific information.

        I know that this would probably be done using some triggers,
however I am not sure on how to get the relevant information (i.e.
user, query,etc...)

       Any help would be appreciated.

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql