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?
