MySQL Bugs: #27928: description for process privilege incorrect

Bug #27928	description for process privilege incorrect
Submitted:	18 Apr 2007 15:03	Modified:	19 Apr 2007 18:49
Reporter:	Scott Noyes (Basic Quality Contributor)	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

Description:
http://dev.mysql.com/doc/refman/5.1/en/grant.html says:
PROCESS 	Enables use of SHOW FULL PROCESSLIST

The PROCESS privilege does not affect use of SHOW FULL PROCESSLIST - a user with USAGE only can still use SHOW FULL PROCESSLIST. 

How to repeat:
mysql> show grants;
+----------------------------------+
| Grants for test@%                |
+----------------------------------+
| GRANT USAGE ON *.* TO 'test'@'%' |
+----------------------------------+
1 row in set (0.00 sec)

mysql> show full processlist;
+----+------+----------------+------+---------+------+-------+-----------------------+
| Id | User | Host           | db   | Command | Time | State | Info                  |
+----+------+----------------+------+---------+------+-------+-----------------------+
| 84 | test | localhost:1025 | NULL | Query   |    0 | NULL  | show full processlist |
+----+------+----------------+------+---------+------+-------+-----------------------+
1 row in set (0.00 sec)

Suggested fix:
Change the documentation on the grant syntax page to show that PROCESS allows the user to see all running processes, not just those which they own, as explained on http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html

Thank you for the report.

Verified as described.

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.