Bug #42157 Missing Privileges for Views

• Submitted: 16 Jan 2009 13:36
• Modified: 16 Apr 2010 12:55
• Reporter: Johannes Taxacher
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.0.29
• OS: Windows
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[16 Jan 2009 13:36] Johannes Taxacher

Description:
as posted on the mysql-forums (http://forums.mysql.com/read.php?152,239376,239376#msg-239376 )  the "assigned privileges"-list on the privileges-tab in Workbenchs view editor lacks default grant options like SELECT, UPDATE, DROP, ...

How to repeat:
- open wb
- add a role
- add a view
- in view editor go to privileges tab
- select role1 in the right list and click the [<] button
- now select the role1 in the left list and see the listed privileges in the middle list

[1 Apr 2010 19:44] Johannes Taxacher

Bug #52041 has been marked as duplicate of this one

[14 Apr 2010 14:07] Alfredo Kojima

Missing privs were added

[16 Apr 2010 9:02] Johannes Taxacher

fix confirmed in repository.

[16 Apr 2010 12:55] Tony Bedford

An entry has been added to the 5.2.19 changelog:

The Assigned Privileges list on the Privileges tab in the View Editor lacked default grant options such as SELECT, UPDATE, and DROP.