Hello, My idea is to have several (about 3) databases. Each DB will have one admin, who is responsible for this DB and doesn't have access to other DBs. The problem is, how to set privileges? I did: GRANT ALL PRIVILEGES on DB1.* to admin1@localhost WITH GRANT OPTION; Then if admin1 is connected, he can do: GRANT SELECT on DB1.* to newuser@localhost .. It works, but the newuser doesn't have password GRANT SELECT on DB1.* to newuser@localhost IDENTIFIED BY 'newuser' .. ERROR 1044: Access denied for user: 'admin1@localhost' to database 'mysql' Finally, is it possible to have admin1 without any access (privileges) in 'mysql' or shell I give him some in mysql (which?). Thanks Jan Stary --------------------------------------------------------------------- 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
