It looks like you are looking for some kind of audit trail......
It would show all the changes to the table data, right?
Sorry, I don't have an answer, but I am looking for some thing similar.
If I find something that falls into this category, I will try to post.
What I have seen in some companies using other databases is, they trap all the transactions in a single table.... but you need to build it in........
Need to keep looking.... there must be a better answer.
At 02:54 PM 1/3/03 +0100, Natale Babbo wrote:
# ---- S.O.S. ---- # hi all,anyone knows how to get the history of updates of a user? ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but they seems not to trace the user that execute the query. is it true? thanks in advance. natale babbo P.S.: plase help me ... any tips are appreciated!! ______________________________________________________________________ Yahoo! Cellulari: scarica i loghi e le suonerie per le tue feste! http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html --------------------------------------------------------------------- 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
