From: Sonam Chauhan
Date: November 13 2000 4:27am
Subject: Question on detailed logging
List-Archive: http://lists.mysql.com/internals/104
Message-Id: <3A0F6DC7.13F7629E@ce.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Is it possible to add additional query-specific information to the MySQL update log ?

e.g.:  
----------LOG EXCERPT------------------------
# User: jj-332 Time: 2000-10-20-22:32 
insert into users set user="ass", ccode = "ass"; 

# User: jj-323 Time: 2000-10-20-22:32 
insert into users set user="ass", ccode = "ewtkwj"; 

# User: jj-344 Time: 2000-10-20-22:32 
insert into users set user="ass", ccode = "ewtkwj"; 
----------/LOG EXCERPT------------------------

This essentially would work as an audit trail.

It would need to pick up additional parameters from the client  
(eg: authenticated webserver user) 
The mySQL server would then add these params to the update log 

Could you cc: me on all replies? I'm not subscribed to all 3 lists. 

Regards,
Sonam Chauhan

Electronic Commerce
Corporate Express Australia Ltd.
Phone: +61-2-9335-0725 Fax: +61-2-9335-0753