"Twibell, Cory L" <[EMAIL PROTECTED]> wrote: > > 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.
You show grants for user ''@'%', but according to error message you connect as ''@'localhost'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]