Bug #47226 Workbench doesn't allow creating roles with priviledges on all tables

• Submitted: 9 Sep 2009 17:57
• Modified: 6 Feb 2013 23:38
• Reporter: Gary Pendergast
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: 5.1.18 SE
• OS: Any
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[9 Sep 2009 17:57] Gary Pendergast

Description:
When creating a user/role, it is not possible to specify mydb.* as the 'object' that the user has privileges on. This would be a handy feature, as a common situation is to have users with the same privileges on all tables in a database.

How to repeat:
- Create a new role
- There is no method to add a generic mydb.* Object to the role

Suggested fix:
Allow a freeform field entry field in Role Objects

[6 Feb 2013 23:38] Alfredo Kojima

This was implemented in 5.2.46