|--------+---------------------------------->
| | Victoria Reznichenko |
| | <[EMAIL PROTECTED]|
| | sita.net>> |
| | |
| | 2003-06-05 11:31 |
|--------+---------------------------------->
>----------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: Problem with adding a new user by non root user with GRANT
OPTION |
>----------------------------------------------------------------------------------------------------------|
"Marcin Blazowski" <[EMAIL PROTECTED]>> wrote:
>> I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS
to
>> that database. When logon with that new user and want to create a new
user
>> with some privileges a get an error.
>>
>> How I do it:
>>
>> mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by
>> 'haslo' with grant option;
>> Query OK, 0 rows affected (0.00 sec)
>>
>> Now, I logon as user temp and create database temp:
>>
>> mysql> create database temp;
>> Query OK, 1 row affected (0.01 sec)
>>
>> And finally I try to give some of my privileges to user temp2:
>>
>> mysql> grant insert on temp.* to [EMAIL PROTECTED] identified by 'haslo';
>> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
>>
>> And I get an access denied error.
>>
>> What's wrong? I know that it should work but it doesn't.
>> It works with MySQL 4.0.12 compiled by me from sources on RedHat.
>> It doesn't work with 3.23.49 installed from deb on Debian.
>> It doesn't work with 4.0.12 installed from binary distribution on
Windows
>> 2000.
>>
>> I think it is because of a configuration of MySQL. But what I have to
>> change? Maybe it is something else?
> User must have UPDATE privilege on the database mysql to grant rights to
other users.
But if I give UPDATE privilege on the database mysql to someuser he will be
able to change root password.
1. How can I create user who will be able to grant rights to other user
without possibility to change passwords in mysql.user?
2. Why everything works like I expect (I can grant privileges with the way
described above, User doesn't have UPDATE privilege) on my MySQL compiled
from sources on RedHat?
3. Why it doesn't work on MySQL installed from binary distribution? Are
there some interesting things in mysql_install_db script?
Thanks a lot for answer.
--
Marcin Blazowski
Incenti SA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
