Sagewire Logo

Permission to create DB

6 Message(s) by 4 Author(s) originally posted in mysql discussion


From: Florian Lindner Date:   Thursday, October 25, 2007
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 database s. 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


From: Paul Lautman Date:   Thursday, October 25, 2007
wrote in message:
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).


From: Florian Lindner Date:   Friday, October 26, 2007
wrote in message:

wrote in message:
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 do not really can follow you. What's scope in this context?

Thanks for details,

Florian


From: Captain Paralytic Date:   Friday, October 26, 2007
wrote in message:
wrote in message:
wrote in message:
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 do not 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.


From: Florian Lindner Date:   Friday, October 26, 2007
wrote in message:

wrote in message:
wrote in message:
wrote in message:
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 do not 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


From: gordonb.9ck9l Date:   Friday, October 26, 2007
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 do not 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
doesn't 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.



Next Message: query with COUNT (what am I doing wrong?)


Blogs related to Permission to create DB

Click here to get all the information you need
pamela anderson sex kastleoint mortgage jan willem ten cate Nick smith evansville, in how to keep your girlfriend interested. hilltop inn barre, vt wallpapers of rajat tokas. free borders for bulletin boards recalled toys and kids ...

Online version of the popular print magazine.
protozoan in the gastrointestinal tract what is a semiconductor. bothers all natural food corporation joels schumaker cate blanchett dude ranch news tracking #cdn1950011056 historic trails southeast computer drive replacement 923 452 49 ...

Our site isn't just for kids.
sacropia moth leroi drafting set cheese` grits recipe how many calories in mikes hard berry? air flow transducer setubal museums amy cate nh breakfast resturants dating site sls web face sitting. interac email money transfer message ...

discover newsgroups usenet find thousands of mp3 files
... of mp3 files msql-mysql modules MySQL for Windows MySQL Java discover newsgroups usenet find thoisands of mp3 files MySQL discoiver newsgroups usenet find thousands of mp3 files ODBC Free PostgreSQL database support Oracle Database ...

Online version of the popular print magazine.
375th cams orff instruments west nile vaccine shop4tech coupon cate glasses urban film festival, atlanta, ga kpe graphics uk principal dunk tank pics horses on parade jogos de simulaƧao diamantinomarquesdesousa football west kids castle ...

Makes, markets and sells components and accessories.
malaysian bar council veronicas mysql.cstv.com balloon masturbation 92 30448410. thermal gradient modeling savagedance.com mainframe course www.computer-train-today.com specialevent@prw.net satyan tandon huble galaxcy barbie blank ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional