Martin, Comments in-line:
> -----Original Message----- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: 16 August 2005 10:35 > To: mysql@lists.mysql.com > Subject: Re: Why can't I revoke usage from user? > > Gleb, > > > Hello. > > > > 'USAGE' means that user doesn't have any privileges. Use > 'DROP USER'. > > See: > > http://dev.mysql.com/doc/mysql/en/drop-user.html > > I disagree here. > > "drop user" will drop the user, revoking "usage" can be > something different. You can't actually revoke USAGE, without dropping the user. > > If, for example, you do "grant usage on dbname.*" this is > different from then "just" a user without "usage" granted to > that database. USAGE is a global level privilege, whilst you can "GRANT USAGE ON test.* ..", it's actually ignored. > > Besides, having a user without privileges might be useful as well :-) Exactly what USAGE is for.. ;) Here's a quick example: mysql> create user frank; Query OK, 0 rows affected (0.00 sec) mysql> show grants for frank; +-----------------------------------+ | Grants for [EMAIL PROTECTED] | +-----------------------------------+ | GRANT USAGE ON *.* TO 'frank'@'%' | +-----------------------------------+ 1 row in set (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | Tracking | | mysql | | test | +--------------------+ 4 rows in set (0.00 sec) mysql> grant usage on test.* to frank; Query OK, 0 rows affected (0.00 sec) mysql> show grants for frank; +-----------------------------------+ | Grants for [EMAIL PROTECTED] | +-----------------------------------+ | GRANT USAGE ON *.* TO 'frank'@'%' | +-----------------------------------+ 1 row in set (0.00 sec) mysql> revoke usage on *.* from frank; Query OK, 0 rows affected (0.00 sec) mysql> show grants for frank; +-----------------------------------+ | Grants for [EMAIL PROTECTED] | +-----------------------------------+ | GRANT USAGE ON *.* TO 'frank'@'%' | +-----------------------------------+ 1 row in set (0.00 sec) Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk http://leithal.cool-tools.co.uk -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.10/73 - Release Date: 15/08/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
