At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
>Hi paul
>
>Paul DuBois wrote:
>
>>At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote:
>>
>>>HI Egor
>>> OK, I want to create new databases, to do that I need database
>>>create privilege.
>>>
>>>Grant CREATE ON ######
>>>to ddb@localhost IDENTIFIED BY 'passwd'
>>>
>>>What should go into #####, is it a *? but I should NOT given
>>>permission to access other databases.
>>
>>
>>No, it should be db_name.*
>
>Then I can ONLY create database called "db_name", then every time
>when I create a database, I have to ask the root to give me create
>permission on xxx database. This is inconvenient. Is there any other
>work around??
As far as I can tell, you're not making any sense:
- First you say you want to grant permission for a given database, and
*NOT* to access other databases.
- Now you say you don't want to have to specify permissions for given
databases.
You can't have it both ways. Do you want permission for a specific
database, or for all databases?
If I am misinterpreting you, then please be more specific.
>Thanks
>
>>
>>
>>>Thanks
>>>
>>>Egor Egorov wrote:
>>>
>>>>vinita,
>>>>Monday, September 23, 2002, 9:12:24 AM, you wrote:
>>>>
>>>>vvM> I can create a database called test,
>>>>vvM> mysql> create database test;
>>>>vvM> Query OK, 1 row affected (0.03 sec)
>>>>
>>>>vvM> BUT I can't create any other databases???
>>>>
>>>>vvM> mysql> create database tem;
>>>>vvM> ERROR 1044: Access denied for user: 'ddb@localhost' to database
> 'tem'
>>>>
>>>>vvM> mysql> create database proj;
>>>>vvM> ERROR 1044: Access denied for user: 'ddb@localhost' to database
> 'proj'
>>>>
>>>>Seems user 'ddb' or anonymous user has privileges only on the database
>>>>'test'.
>>>
>>
>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>>To request this thread, e-mail <mysql-thread120358@stripped>
>>To unsubscribe, e-mail <mysql-unsubscribe-##L=##H@stripped>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread120362@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-##L=##H@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
