Hello Carl, Friday, February 01, 2002, 12:17:07 AM, you wrote:
CM> Victoria, CM> I'm pretty new and this and have a similar need so I played with the steps CM> you posted. However, the revoke command did not work. I received the error CM> "ERROR 1141: There is not such grant defined for user 'userid' on host '%'". As I have told, you can't set "all privileges excluding one". Currently it's not supported. If you set global privileges, MySQL adds rows only to table "user" in mysql database. If you revoke grants from user on some databases (as mysql db), you change the "db" table in mysql database instead of table "user", but there are no records in table "db" which can determine grants for your root user :( CM> Any thoughts? CM> If you create user with privileges on all databases (*.*), you get access CM> not only to user's databases but also to mysql db. It's impossible to create CM> user with all privileges but exclude something you want. CM> You set privileges on global level and statement like the following works CM> using table "user" mysql db: CM> GRANT ALL ON *.* TO ''@localhost CM> If you want to take off grants from user on mysql.*, it will work on CM> database level with table "db" mysql db: CM> REVOKE UPDATE ON mysql.* FROM ''@localhost -- For technical support contracts, goto https://order.mysql.com/ 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