MySQL Forums
Forum List  »  MySQL Administrator

Grant CREATE to user, cannot grant self privileges
Posted by: Jonathan Morrison
Date: January 29, 2010 06:25AM

I have given an existing user the ability to create (with an expectation of them creating their own databases) using the following statement:

GRANT CREATE ON *.* TO 'user'@'localhost' WITH GRANT OPTION

The user can now create a database, connect to it and create tables, but cannot assign themselves any privileges to use it.

e.g. user tries to GRANT SELECT ON `newdb`.* TO 'user'@'localhost' and gets:
ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database newdb

Could I have some suggestions as to how to enable a user to create their own database, and use it?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Grant CREATE to user, cannot grant self privileges
January 29, 2010 06:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.