Comment 1 for bug 1354988

Revision history for this message
Vlad Lesin (vlad-lesin) wrote :

The bugfix was contributed to upstream (http://bugs.mysql.com/bug.php?id=53645&contribs=1) and the bug report was reclassified as feature request:

Thank you for the contribution. But as our documentation (http://dev.mysql.com/doc/refman/5.7/en/show-grants.html) clearly states:

"SHOW GRANTS displays only the privileges granted explicitly to the named account. Other privileges might be available to the account, but they are not displayed. For example, if an anonymous account exists, the named account might be able to use its privileges, but SHOW GRANTS will not display them. "

However I do agree that the effective privileges is a really nice information to have. Thus I believe this is a very relevant feature request. Reclassifying it as such.