Bug #39652 SHOW GRANTS FOR <user>: Not clear which privileges needed to call it
Submitted: 25 Sep 2008 15:00 Modified: 30 Sep 2008 17:37
Reporter: Andrii Nikitin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[25 Sep 2008 15:00] Andrii Nikitin 
Description:
It is not clear from documentation which privileges should user have to be able call command:
SHOW GRANTS FOR <user>

How to repeat:
See http://dev.mysql.com/doc/refman/5.0/en/show-grants.html
it is not intuitive that user should have SELECT access to 'mysql' database.
(although error message provides a hint)

Suggested fix:
Maybe put this sentence in the paragraph:
"To be able execute SHOW GRANTS FOR <user> one should have SELECT privilege for mysql.* database"
[25 Sep 2008 16:28] Valeriy Kravchuk 
Thank you for a reasonable documentation request.
[30 Sep 2008 17:37] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

SHOW GRANTS requires SELECT for the mysql database.