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? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
