MySQL Bugs: #56346: [UI] Improving task of privilege assignment to user role

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:	None
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

Description:
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.

Thank you for the feature request.

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.

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.