Well, with that in mind, does the user have the appropriate INSERT privileges?
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 3:49 PM > To: Mike Hillyer; Twibell, Cory L; [EMAIL PROTECTED] > Subject: RE: Help with privilege tables - IMPORTANT > > > My user in the user table has NO privileges. All privileges > for that user > are done in the db table. Using MySQL 4.1.0-alpha > > -----Original Message----- > From: Mike Hillyer [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 3:41 PM > To: Twibell, Cory L; [EMAIL PROTECTED] > Subject: RE: Help with privilege tables - IMPORTANT > > > Well, you do not show what UPDATE privileges your user possesses, so I > am not sure where your problem lies. However, 2.23.57 has a > fix that may > be relevant to your situation: > > "Fixed security problem where mysqld didn't allow one to > UPDATE rows in > a table even if one had a global UPDATE privilege and a > database SELECT > privilege." http://www.mysql.com/doc/en/News-3.23.57.html > > But it depends on how you GRANTed UPDATE privileges. > > Regards, > Mike Hillyer > www.vbmysql.com > > > > -----Original Message----- > > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 30, 2003 3:26 PM > > To: '[EMAIL PROTECTED]' > > Subject: Help with privilege tables - IMPORTANT > > > > > > 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/mysql?> [EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
