Bug #63042 Workbench users and privileges lacks way to view or create detailed grants

• Submitted: 31 Oct 2011 15:33
• Modified: 31 Oct 2011 15:51
• Reporter: Byron Palmer
• Status: Duplicate
• Category: MySQL Workbench: Administration
• Severity: S4 (Feature request)
• Version: 5.2.35
• OS: Any
• CPU Architecture: Any

[31 Oct 2011 15:33] Byron Palmer

Description:
There is no way to view or change detailed grants at the level of tables, routines, or views. Because of the need for security this is often useful to restrict individual users to a small subset of the tables. The only way to do this is through command line sql rather than a gui. The old administrator had that ability. 

How to repeat:
Go into the Users and Privileges in Management. Look at the schema privileges and you will not see the grants for individual entities. All you see are grants to a schema.

Suggested fix:
Add in a well designed interface to manage grants. I would also suggest that you sort the users in the users and privileges second screen. The users are random whereas in the first screen they are alphabetical.

[31 Oct 2011 15:51] Alfredo Kojima

Duplicate of bug #61066