(more concise) db admin question

2003-07-19 Thread Ed Brown
To restate an earlier question more concisely: Is it true that a user who is given all privileges, including grant option, on a database (e.g., in order to administer that database) can create other users with any or all of his privileges, but cannot give them passwords? Is there some wa

creating db admins

2003-07-19 Thread Ed Brown
I create a database, foo, then designate a user, pooh, with full privileges, including grant option (pooh is to administer this database, including creating other users): grant all on foo.* to 'pooh'@'localhost' identified by 'zoo' with grant option; Now pooh logs in to the mysql server