List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 16 2005 9:13am
Subject:Re: Why can't I revoke usage from user?
View as plain text  
Hello.

'USAGE' means that user doesn't have any privileges. Use 'DROP USER'.
See:
  http://dev.mysql.com/doc/mysql/en/drop-user.html

Gu Lei <leig@stripped> wrote:
> Hello everyone:
> 
> Why can't I revoke usage from user?
> mysql> show grants for ''@'172.20.16.110';
> +------------------------------------------+
> | Grants for @172.20.16.110                |
> +------------------------------------------+
> | GRANT USAGE ON *.* TO ''@'172.20.16.110' |
> +------------------------------------------+
> 1 row in set (0.00 sec)
> 
> mysql> revoke usage on *.* from ''@'172.20.16.110';
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> show grants for ''@'172.20.16.110';
> +------------------------------------------+
> | Grants for @172.20.16.110                |
> +------------------------------------------+
> | GRANT USAGE ON *.* TO ''@'172.20.16.110' |
> +------------------------------------------+
> 1 row in set (0.00 sec)
> 
> Thanks.
> 
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Why can't I revoke usage from user?Gu Lei16 Aug
  • Re: Why can't I revoke usage from user?Gleb Paharenko16 Aug
  • Re: Why can't I revoke usage from user?Martijn Tonies16 Aug
  • Re: Why can't I revoke usage from user?Martijn Tonies16 Aug
    • RE: Why can't I revoke usage from user?Mark Leith16 Aug
      • Re: Why can't I revoke usage from user?Martijn Tonies16 Aug