Yes you can.. We have a log called mysql.log that has user@IP/domain and then the question. All you need to do is edit my.cnf to make shore it is on. We keep all the logs can just gunzip them up.....all you need is a perl script to get the data back out.
Simon -----Original Message----- From: Frederico Martins [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 16:17 To: '[EMAIL PROTECTED]' Subject: Audit - Log Hi, I've installed MySql on a RedHat box and configured log-bin. Everything is running OK. My question is, if a user does any insert, delete or update, can I see which user (username) has performed that action? Where can I log this information and retrieve it later, for auditing purposes? Thanks Frederico Martins --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
