Caron, Thursday, August 01, 2002, 5:34:16 PM, you wrote: C> mysql> show grants for nouveau@localhost; C> +--------------------------------------------------------------------------- C> ------------+ C> | Grants for nouveau@localhost | C> +--------------------------------------------------------------------------- C> ------------+ C> | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD C> '4be6641910d7bc1b' | C> +--------------------------------------------------------------------------- C> ------------+ C> 1 row in set (0.00 sec)
C> mysql> revoke usage on *.* from nouveau@localhost; C> Query OK, 0 rows affected (0.00 sec) C> Is there a way to get rid of that? :-) Yes, give to user 'nouveau' any privileges except USAGE. USAGE is a synonim for 'no privileges'. C> Is there a way to create a user by giving access to only one database, C> without giving him the permission to "mysqlshow --user=[thisuser] C> --password=[thispassword]" and retrieve all database names? He should see C> only the name of his database...? Yes, start mysqld with --safe-show-database option. And since 4.0.2 there is a SHOW DATABASES privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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