| localhost | testdb | testuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y |
the N is Grant_priv I don't understand why? thanks... Cheers, Clive -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 1:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database At 12:48 PM +1100 10/27/03, Clive Luk wrote: >Hi paul, > >Thanks for the quick reply. > >I have revoke all the privileges and ran > >grant all privileges on testdb.* to [EMAIL PROTECTED]; > >and i login as testuser and i have confirm with select Current_user(); that >i am a testuser; > >and i can still select on mysql.user. > >just an info. > >select * from mysql.user where user='testuser'; > >| localhost | testuser | xxxxxxxxxxxxx | N | N | N >| N | N | N | N | N | N >| N | N | N | N | N | N >| N | N | N | N | N >| N | | | | | >0 | 0 | 0 | > >any clue? What does SELECT * FROM mysql.db WHERE User='testuser' show? > >Cheers, >Clive -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]