MySQL Forums
Forum List  »  Security

Advanced Search
New Topic

Re: grant create user on database
Posted by: Devart Team
Date: May 05, 2009 02:56AM

You cannot grant CREATE USER privilege for a specified database, only globally.
There is a quotation from MySQL documentation:
"The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, SUPER, and CREATE USER privileges are administrative privileges that can only be granted globally (using ON *.* syntax)."

If you use the Security Manager in the dbForge Studio for MySQL, you won't have such problems in the future.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
grant create user on database
12364
Bob Chti
April 27, 2009 09:04AM
Re: grant create user on database
6510
Devart Team
May 05, 2009 02:56AM


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.