MySQL version 3.23.39. I'd like to distribute MySQL user administration by database using the WITH GRANT OPTION feature. I gave user "joe" all privileges on his own database with grant privilege. joe can grant privileges on his own database to other users, but cannot assign them passwords. Example: mysql> show tables; +---------------+ | Tables_in_joe | +---------------+ | parts | +---------------+ 1 row in set (0.00 sec) mysql> grant select on parts to bob@localhost; Query OK, 0 rows affected (0.00 sec) mysql> grant select on parts to ed@localhost identified by 'ed'; ERROR 1044: Access denied for user: 'joe@localhost' to database 'mysql' mysql> Apparently, joe requires access to the mysql database to fill in a password for ed, which I'd rather not give. This seems like a major failing with the WITH GRANT feature as the only way for non-global users to grant rights to their database is without a password. Am I missing something or is there a feature or workaround for such users to assign passwords to their grants using MySQL's access control system? -- Michael Burns Systems Administrator Vener Net Inc. [EMAIL PROTECTED] --------------------------------------------------------------------- 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
