| Bug #79871 | Crash on Alter Stored Procedure if disabled SELECT from Administrative Roles | ||
|---|---|---|---|
| Submitted: | 7 Jan 2016 8:42 | Modified: | 16 May 2016 23:34 |
| Reporter: | Eugene Mitev | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S1 (Critical) |
| Version: | 6.3.6 Build 511 | OS: | Windows (7) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | administrative roles, crash, hang, privilege, SELECT | ||
[7 Jan 2016 8:57]
MySQL Verification Team
Hello Eugene Mitev, Thank you for the report. Verified as described with WB 6.3.6 on Win7. Thanks, Umesh
[3 Feb 2016 3:21]
Juan Pablo Realini
Hi.. I am having the same issue here.. Windows 7, Workbench 6.3. I downloaded it because I am having an issue, I created a stored procedure in a remote MySql server, and now I can't edit it (Edit button is grayed out in PHPMyAdmin)... Tried workbench, but when I try to Alter Stored Procedure... it crashes... I checked the db user's privileged, and it has all privileges active... Any hint please??
[28 Feb 2016 22:20]
MySQL Verification Team
http://bugs.mysql.com/bug.php?id=80548 marked as duplicate of this one.
[16 May 2016 23:34]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry: Executing Alter Stored Procedure with a user lacking SELECT privileges would crash MySQL Workbench. Thank you for the bug report.
Description: When "SELECT" is disabled in "Administrive Roles", Workbench crashed if you click "Alter Stored Procedure ..." from the "Navigator" tab. How to repeat: For some user: In "Administrive Roles" disable "SELECT". Login as specified user. In "Navigator" Tab: ->some_schema ->"Stored Procedures" ->some_procedure ->(right_mouse_click or menu_key) from drop-down menu select "Alter Stored Procedure ...". KABOOM! Suggested fix: duh