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
...