Bug #39652 SHOW GRANTS FOR <user>: Not clear which privileges needed to call it
Submitted: 25 Sep 2008 17:00 Modified: 30 Sep 2008 19:37
Reporter: Andrii Nikitin
Status: Closed
Category:Server: Docs Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois Target Version:
Triage: D4 (Minor)

[25 Sep 2008 17: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 18:28] Valeriy Kravchuk 
Thank you for a reasonable documentation request.
[30 Sep 2008 19: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.