Skip navigation links

MySQL Forums :: Microsoft Access :: Grant Create database permission to a user


Advanced Search

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.

Options: ReplyQuote


Subject Views Written By Posted
Grant Create database permission to a user 3219 P M 09/23/2009 06:12AM
Re: Grant Create database permission to a user 2338 Jay Alverson 09/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.