Permission to create DB
This is a discussion on Permission to create DB within the MySQL Database forums, part of the Database Forums category; Hallo, I use phpMyAdmin (most recent version) to adminstrate an MySQL 5.0 server. I have created an user wuhr ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
10-25-2007
|
|||
|
|||
Permission to create DB
Hallo,
I use phpMyAdmin (most recent version) to adminstrate an MySQL 5.0 server. I have created an user wuhr who permission for the DB wuhr\_%: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE Now I'm suprised that the user is permitted to create new databases. CREATE gives according to phpMyAdmin the permission to create tables and DBs. Now I want to the user to be able to create tables but not DBs. How can I do that? Thanks, Florian 
|
|
10-25-2007
|
|||
|
|||
|
Re: Permission to create DB
Florian Lindner wrote:
> Hallo, > I use phpMyAdmin (most recent version) to adminstrate an MySQL 5.0 > server. > > I have created an user wuhr who permission for the DB wuhr\_%: > SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE > TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER > ROUTINE, EXECUTE > > Now I'm suprised that the user is permitted to create new databases. > CREATE gives according to phpMyAdmin the permission to create tables > and DBs. Now I want to the user to be able to create tables but not > DBs. > > How can I do that? > > Thanks, > > Florian Set the user's scope to be a particular database (or set of databases).
|
|
10-26-2007
|
|||
|
|||
|
Re: Permission to create DB
Paul Lautman wrote:
> Florian Lindner wrote: >> Hallo, >> I use phpMyAdmin (most recent version) to adminstrate an MySQL 5.0 >> server. >> >> I have created an user wuhr who permission for the DB wuhr\_%: >> SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE >> TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER >> ROUTINE, EXECUTE >> >> Now I'm suprised that the user is permitted to create new databases. >> CREATE gives according to phpMyAdmin the permission to create tables >> and DBs. Now I want to the user to be able to create tables but not >> DBs. >> >> How can I do that? >> >> Thanks, >> >> Florian > > Set the user's scope to be a particular database (or set of databases). Sorry, I don't really can follow you. What's scope in this context? Thanks for details, Florian
|
|
10-26-2007
|
|||
|
|||
|
Re: Permission to create DB
On 26 Oct, 10:26, Florian Lindner <Florian.Lind...@xgm.de> wrote:
> Paul Lautman wrote: > > Florian Lindner wrote: > >> Hallo, > >> I use phpMyAdmin (most recent version) to adminstrate an MySQL 5.0 > >> server. > > >> I have created an user wuhr who permission for the DB wuhr\_%: > >> SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE > >> TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER > >> ROUTINE, EXECUTE > > >> Now I'm suprised that the user is permitted to create new databases. > >> CREATE gives according to phpMyAdmin the permission to create tables > >> and DBs. Now I want to the user to be able to create tables but not > >> DBs. > > >> How can I do that? > > >> Thanks, > > >> Florian > > > Set the user's scope to be a particular database (or set of databases). > > Sorry, I don't really can follow you. What's scope in this context? > > Thanks for details, > > Florian- Hide quoted text - > > - Show quoted text - The scope within which the user may operate. As documented in the manual.
|
|
10-26-2007
|
|||
|
|||
|
Re: Permission to create DB
Captain Paralytic wrote:
> On 26 Oct, 10:26, Florian Lindner <Florian.Lind...@xgm.de> wrote: >> Paul Lautman wrote: >> > Florian Lindner wrote: >> >> Hallo, >> >> I use phpMyAdmin (most recent version) to adminstrate an MySQL 5.0 >> >> server. >> >> >> I have created an user wuhr who permission for the DB wuhr\_%: >> >> SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE >> >> TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER >> >> ROUTINE, EXECUTE >> >> >> Now I'm suprised that the user is permitted to create new databases. >> >> CREATE gives according to phpMyAdmin the permission to create tables >> >> and DBs. Now I want to the user to be able to create tables but not >> >> DBs. >> >> >> How can I do that? >> >> >> Thanks, >> >> >> Florian >> >> > Set the user's scope to be a particular database (or set of databases). >> >> Sorry, I don't really can follow you. What's scope in this context? >> >> Thanks for details, >> >> Florian- Hide quoted text - >> >> - Show quoted text - > > The scope within which the user may operate. As documented in the > manual. Is it possible that you give me an pointer where it's to find in the manual? Thanks, Florian
|
|
10-26-2007
|
|||
|
|||
|
Re: Permission to create DB
>>> >> I have created an user wuhr who permission for the DB wuhr\_%:
>>> >> SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE >>> >> TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER >>> >> ROUTINE, EXECUTE >>> >>> >> Now I'm suprised that the user is permitted to create new databases. >>> >> CREATE gives according to phpMyAdmin the permission to create tables >>> >> and DBs. Now I want to the user to be able to create tables but not >>> >> DBs. >>> >>> >> How can I do that? >>> >>> > Set the user's scope to be a particular database (or set of databases). >>> >>> Sorry, I don't really can follow you. What's scope in this context? >>> >>> Thanks for details, >>> >> The scope within which the user may operate. As documented in the >> manual. > >Is it possible that you give me an pointer where it's to find in the manual? User privileges have scope. A privilege can apply globally, to a database, or to specific tables, depending on the privilege (It does not make sense to grant "SHUTDOWN" privilege on a specific table only) and how you GRANTed it. For example, you could grant CREATE only on a specific database. Look at documentation for the GRANT command for details.
|
Linear Mode
