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/
