Bug #70258 Requirement for PROCESS privilege not documented
Submitted: 6 Sep 2013 10:24 Modified: 30 Sep 2013 16:51
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5+ OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[6 Sep 2013 10:24] Peter Laursen 
Description:
Neither of the pages 
http://dev.mysql.com/doc/refman/5.6/en/show-engine.html
http://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html#priv_process

.. tell that PROCESS privilege is required for "SHOW ENGINE performance_schema STATUS"

How to repeat:
SHOW ENGINE performance_schema STATUS;
-- Error Code: 1227
-- Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

Suggested fix:
Even if the requirement should be listed somewhere else in documentation (somewhere I did not find, then) I think the above two pages should clarify. IMO that would be the obvious places to have this.
[6 Sep 2013 11:52] MySQL Verification Team 
Thank you for the bug report.
[30 Sep 2013 16:42] Paul DuBois 
Looks like SHOW ENGINE ... STATUS and MUTEX require PROCESS, and SHOW ENGINE ... LOGS requires FILE.
[30 Sep 2013 16:51] 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.