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]
