Grant Create database permission to a user
Date: September 23, 2009 06:12AM
I have created user as follows:
grant all on test.* to 'user1'@'localhost' identified by 'password'
after I login as 'user' , I am unable to create a database. I get the error message:
ERROR 1044 (42000): Access denied for user 'user1'@'localhost' to database 'dummy'
What is the problem? How can permissions be granted to this user to create databases.
I also tried to grant all on *.*, but this way the user can access all the databases that this user is not suppose to access. There is no way to REVOKE permission to a single database.
How to Grant Create database permission to a user?
Thanks in advance.
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.