I am using mysql-4.0.5a-beta on Linux Redhat 7.3 server with php-4.3.0RC1
When I connect and execute my quiries as root user my query of multi-table update works fine update Stockists , areas set Stockists.a_nm = areas.aname where Stockists.area=areas.acd Query Executed OK , one row affected The Query results are OK But when I execute the same query with different user having update and lock table previledges I get error update command denied to user: 'aldixit@localhost' for table 'areas' What previledges are required for user to execute multi-table update? Regards Ajit Dixit ------------------------------------------------- This mail sent through http://shreya.co.in/ --------------------------------------------------------------------- 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
