That is my conclusion as well. I think you should post it as such barring any comments otherwise.
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 4:51 PM > To: Mike Hillyer; [EMAIL PROTECTED] > Subject: RE: Help with privilege tables - IMPORTANT > > > Yes, I have the UPDATE for table B. I belive this is a bug. > > -----Original Message----- > From: Mike Hillyer [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 4:47 PM > To: Twibell, Cory L; [EMAIL PROTECTED] > Subject: RE: Help with privilege tables - IMPORTANT > > > 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]
