Bug #56346 [UI] Improving task of privilege assignment to user role
Submitted: 28 Aug 2010 20:45 Modified: 21 Aug 2014 20:47
Reporter: Peta Byte Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.26 OS:Any
Assigned to: CPU Architecture:Any
Tags: assignment, checkbox, GUI, privileges, roles, selection, UI, useability, users
Triage: Needs Triage: D5 (Feature request)

[28 Aug 2010 20:45] Peta Byte
Assigning every single privilege individually role permissions for every single table is a recurring and time-consuming task. Unfortunately theres currently no way to straighten this tasks.

How to repeat:
1.) Create a Schema Privilege Role
2.) Assign privileges for one/multiple table objects

Suggested fix:
It would be great if you could add a "Check All Privileges" button right next to the existing "Uncheck all Privileges" one. Beside that it would be straightforward if the user could select multiple tables in the "Objects" list and then assign privileges that will apply to all selected ones.
[29 Aug 2010 7:00] Valeriy Kravchuk
Thank you for the feature request.
[26 Jun 2014 21:31] Alfredo Kojima
Posted by developer:
Added a button for checking all privileges in a role. Also added a context menu item to add all tables in a schema.
[21 Aug 2014 20:47] Philip Olson
Fixed as of the MySQL Workbench 6.2.0 release, and here's the changelog entry:

A a new context menu item was added to add all tables in the privileges
role editor. 

A new button was added to select all privileges when assigning
privileges to a role.

Thank you for the bug report.