MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:August 28 2002 2:51pm
Subject:Re: granting grant option creates user ?!
View as plain text  
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;

MR> creates a user somene - with no password. 

MySQL creates new user when in the table 'user' there is no existing user
with the same user name and host name.

New user doesn't have a password because you don't specify a password
in the GRANT statement.

MR> but what strikes me most is - it can create a user!!!

Yes, if the user has UPDATE privilege on the database 'mysql'.

For technical support contracts, goto
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

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