Re: Why can't I revoke usage from user?

2005-08-16 Thread Martijn Tonies
Hi there, > > > > > > '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 actual

RE: Why can't I revoke usage from user?

2005-08-16 Thread Mark Leith
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. > > >

Re: Why can't I revoke usage from user?

2005-08-16 Thread Martijn Tonies
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. If, for example, you do "grant usage on dbname.*" th

Re: Why can't I revoke usage from user?

2005-08-16 Thread Martijn Tonies
Hi, > 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' | > +

Re: Why can't I revoke usage from user?

2005-08-16 Thread Gleb Paharenko
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 <[EMAIL PROTECTED]> wrote: > Hello everyone: > > Why can't I revoke usage from user? > mysql> show grants for ''@'172.20.16.110'; > +