List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 24 2002 3:36am
Subject:Re: Re: mysqlimport
View as plain text  
sql,query


>>>HI sorry for the confusion.
>>>well...... I want to create a database where I can give *any* name
>>>(ofcourse, the database doesn't exist).
>>>
>>>Are you trying to say, I need to ask the root, to give me create
>>>privilege on database "xxx", even before it exist, then only I can
>>>create the database "xxx". Then every time when I want to create a
>>>new database, I need to ask the root to give create privilege ???
>>
>>
>>Well, yes, you need to have privileges on a database to be able to create
>>it.  However, if you have the global CREATE privilege, you can create *any*
>>database.  So maybe that's what you want.  The GRANT statement for
>>this will look like:
>>
>>GRANT CREATE ON *.* TO ddb@localhost IDENTIFIED BY 'passwd';
>>
>>*.* as a level specifier means "global".
>>
>>Is that what you want?
>
>
>Yes....! here I go again!!
>If I get the global CREATE, yes I can create any databases, but also
>it will allows me to create tables under any database?? isn't that
>right??

Right.  CREATE applies both to databases and to tables.  There are
not separate create-database and create-table privileges.

>Is it possible, i can create new databases (with any name) but I
>will not have any access to other existing database??
>Thanks

No.
Thread
Re: Re: mysqlimportPaul DuBois24 Sep
Re: Re: mysqlimportPaul DuBois24 Sep