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
| Thread |
|---|
| • Question on detailed logging | Sonam Chauhan | 13 Nov |