[Phpmyadmin-devel] 1295022 - Privileges for non superuser

[Marc Delisle]

Aaron Maturen a écrit :
> I do. 
> Is it possible? The grant tab seems to be based off a list from mysql.user Which is the check that is being prevented with "PMA_DBI_try_query('SELECT COUNT(*) FROM mysql.user', $GLOBALS['userlink'], PMA_DBI_QUERY_STORE)" to set the superuser
> 
> -Aaron T. Maturen

 From the MySQL doc:

"SHOW GRANTS  requires the SELECT privilege for the mysql database."

So you need this kind of privileges to be able to list privileges for 
other users, unless there is some other way that I'm not aware of.

In the RFC, the person mentions that the account he's trying to use is 
allowed to do GRANT to create users, so maybe he also has SELECT on the 
"mysql" database?

> 
> ----- Original Message -----
> From: "Marc Delisle" <marc at infomarc.info>
> To: phpmyadmin-devel at lists.sourceforge.net
> Sent: Wednesday, April 14, 2010 9:29:35 AM GMT -05:00 US/Canada Eastern
> Subject: Re: [Phpmyadmin-devel] 1295022 - Privileges for non superuser
> 
> Aaron Maturen a écrit :
>> I guess I'm getting tired. Its already part of adding a new user. Just for reference heres the link to the bug tracker: https://sourceforge.net/tracker/index.php?func=detail&aid=1295022&group_id=23067&atid=377411 .
> 
> Aaron,
> just to be sure, do you still have a question about this?
> 
> 


-- 
Marc Delisle
http://infomarc.info