List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 29 2002 3:01am
Subject:Re: granting grant option creates user ?!
View as plain text  
At 17:51 +0300 8/28/02, Victoria Reznichenko wrote:
>Markus,
>Wednesday, August 28, 2002, 3:48:42 PM, you wrote:
>
>MR> we are using mysql 3.23... for our webservices.=20
>MR> the following question about grant:
>MR> granting grant option to a user has the consequence, that this 
>user can grant to other users - even if this other user doesn't 
>exist!!
>
>MR> e.g. grant grant option on db.* to somene;
>
>It's a wrong syntax. You should use GRANT .. WITH GRANT OPTION;

It's not wrong, it's allowed by MySQL's grammar.  It's simply
not used as often.  (Maybe it *shouldn't* be allowed by the grammar,
but that's a different question.)

>
>MR> creates a user somene - with no password.

How could you grant the privilege to the user *without* creating
the user?


Thread
granting grant option creates user ?!Markus Reger28 Aug
  • Re: granting grant option creates user ?!Victoria Reznichenko28 Aug
    • Re: granting grant option creates user ?!Paul DuBois29 Aug