On 16 Jun 2005, at 18:11, Niall Walsh wrote:
>> mysql> show grants for boss at some.mysql.server \G
>> *************************** 1. row ***************************
>> Grants for boss at some.mysql.server: GRANT SELECT, INSERT, UPDATE,
>> DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES,
>> INDEX, ALTER ON *.* TO 'boss'@'some.mysql.server' IDENTIFIED BY
>> PASSWORD '1a2154e5660c6374' WITH GRANT OPTION
>> 1 row in set (0.00 sec)
>>>> but yet I can't grant access to a database:
>>> That's because you don't have grant rights!
What part of "WITH GRANT OPTION" did you not see in the above list?
>> mysql> grant all on sample.* to someuser at some.mysql.server IDENTIFIED
>> BY "somePass";
>> ERROR 1044: Access denied for user: 'boss at some.mysql.server' to
>> database 'sample'
>>>> Note that I can grant all privileges to someuser if I name them -
>> it's the "all" shorthand which doesn't work.
>>> I guess your weren't naming GRANT OPTION then :-P
No, I wasn't - nor did I want to be. As you pointed out, GRANT ALL
doesn't give the grant privilege. I don't want to give the grant
privilege to someuser but I had given the grant privilege to boss.
Niall
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
