Bug #54153 Role editor has no method of doing schema.*
Submitted: 1 Jun 2010 16:19 Modified: 25 Jan 2013 8:32
Reporter: Jeremy Tinley Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.21 OSS RC OS:Windows (7.0)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: role

[1 Jun 2010 16:19] Jeremy Tinley 
Description:
You cannot create a role that has access to schema.*

How to repeat:
Create a new user, then a new role.  You cannot drag the entire schema down to the box, you must pick individual tables.

Suggested fix:
Would expect either to drag and drop the schema down to the pane or populate the the Objects pane with a list of available schema and tables using checkboxes to set them.
[29 Dec 2012 1:14] Alfredo Kojima 
Bug #60260 is a duplicate of this
[25 Jan 2013 8:32] Philip Olson 
Fixed as of the upcoming MySQL Workbench 5.2.46 release, and here's the changelog entry:

New role functionality was added. It is now is possible to add schemas.*,
tables.*, and *.*, and to assign privileges to each object. Before it was
only possible to add individual tables when defining roles.

Thank you for the bug report.