All, I have the user table which contains user record | Host | User| Pass | Select...| ------------------------------------------- |% | | | N... |
The db record is | Host | Db | User | Select...| ------------------------------------------ | % | Test1 | | 'Y'... | | % | Test2 | | 'Y'... | All privileges are Y in the db table. When I try to do a MULTI table update like: update Test1 A, Test2 B set A.value = 'VALUE' where A.ID = B.ID; All I get is 'update not allowed for user (@localhost)'..... When I changed the user table to allow the global update and select privilege, it worked. Is the multi table update correct for the privileges tables? I don't want the user to have global access, only db access. Thanks Cory Twibell Lockheed Martin Space Systems Company Electronic Combat Development Systems [EMAIL PROTECTED] (303) 971-3184 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]