Grant Create database permission to a user
Posted by:
P M
Date: September 23, 2009 06:12AM
Hi,
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.
Subject
Views
Written By
Posted
Grant Create database permission to a user
4869
September 23, 2009 06:12AM
2912
September 23, 2009 09:45AM
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.