Hmm, if you have UPDATE privilege on A and SELECT on A and B then it should work. Do you have UPDATE granted on B (though I know you should not need it)?
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 4:26 PM > To: Mike Hillyer; Twibell, Cory L; [EMAIL PROTECTED] > Subject: RE: Help with privilege tables - IMPORTANT > > > Ok, the user has the appropriate privileges in the db table. > The user can select, insert, update, delete....whatever. > What he CAN'T do is a MULTI-TABLE UPDATE using just the db > privileges table. > > -----Original Message----- > From: Mike Hillyer [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 4:22 PM > To: Twibell, Cory L; [EMAIL PROTECTED] > Subject: RE: Help with privilege tables - IMPORTANT > > > 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]
