Bug #59275 SHOW PRIVILEGES doesn't have an entry for the PROXY privilege

• Submitted: 4 Jan 2011 10:53
• Modified: 29 Jan 2011 23:19
• Reporter: Georgi Kodinov
• Status: Closed
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 5.5
• OS: Any
• Assigned to: Georgi Kodinov
• CPU Architecture: Any
• Tags: wl1054

[4 Jan 2011 10:53] Georgi Kodinov

Description:
the MySQL statement SHOW PRIVILEGES should have a line for PROXY, for example

mysql> show privileges;                                                                                       

+---------------+-------------------+------------------------------+                              
| Privilege     | Context           | Comment                      |
+---------------+-------------------+------------------------------+
| Alter         | Tables            | To alter the table           |
...
| Proxy         | Server Admin      | To make proxy users possible |
...

How to repeat:
SHOW PRIVILEGES

Suggested fix:
Add the line above

[14 Jan 2011 14:59] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/128802

3247 Georgi Kodinov	2011-01-14
      Bug #59275: SHOW PRIVILEGES doesn't have an entry for the PROXY privilege
      
      Added the privilege to the SHOW command.

[24 Jan 2011 15:26] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/129454

3273 Georgi Kodinov	2011-01-14
      Bug #59275: SHOW PRIVILEGES doesn't have an entry for the PROXY privilege
      
      Added the privilege to the SHOW command.

[24 Jan 2011 15:49] Bugs System

Pushed into mysql-trunk 5.6.2 (revid:[e-mail]-20110124154716-9ca9rjaw3smuu1kh) (version source revid:[e-mail]-20110124154716-9ca9rjaw3smuu1kh) (merge vers: 5.6.2) (pib:24)

[24 Jan 2011 15:49] Bugs System

Pushed into mysql-5.5 5.5.10 (revid:[e-mail]-20110114145713-hcfyq6mr77iwa23j) (version source revid:[e-mail]-20110114145713-hcfyq6mr77iwa23j) (merge vers: 5.5.10) (pib:24)

[24 Jan 2011 20:08] Paul DuBois

Noted in 5.5.10, 5.6.2 changelogs.

SHOW PRIVILEGES did not display a row for the PROXY privilege.