MySQL Bugs: #60260: Cannot add schema object to privilege definition in role editor

Bug #60260	Cannot add schema object to privilege definition in role editor
Submitted:	25 Feb 2011 23:26	Modified:	29 Dec 2012 1:13
Reporter:	Charles Bailey	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S4 (Feature request)
Version:	5.2.31	OS:	MacOS (10.6)
Assigned to:		CPU Architecture:	Any

Description:
The role editor in the model view states that one should "Drag objects from the Catalog tree to the Objects list to give rights on it".  Unfortunately, the Catalog tree is not visible in the model window (see attached screenshot).  One can drag individual tables and views into the role editor, but it does not appear to be possible to address the schema as a whole.  For multi-table schemata, this means privileges need to be re-assigned for each table and view.  It would be helpful, in terms of both repetition in Workbench and in the DDL generated, to be able to assign privileges for the schema as a whole.

Thanks!

How to repeat:
1. Open or create a new model
2. Add one or more tables
3. Add a role
4. Switch to the privileges tab for the new role
5. Drag individual table(s) to the role editor -- success.
6. Attempt to drag the schema as a whole to the editor -- not possible.

Suggested fix:
Perhaps offering the Catalog tree tab in the sidebar here would yield a draggable representation of the schema.

I see two problems here:

1. This text,  "Drag objects from the Catalog tree to the Objects list to give rights on it", is wrong, as Catalog tree is not visible when role editor tab is opened.

2. No way to add privileges at schema level for the role.

I see two problems here:

1. This text,  "Drag objects from the Catalog tree to the Objects list to give rights on it", is wrong, as Catalog tree is not visible when role editor tab is opened.

2. No way to add privileges at schema level for the role.

I would like to confirm this bug.

An additional note about this is that selecting multiple objects with the shift key and then dragging them into the Objects box only adds one object.

Without the ability to add an entire schema or multiple objects the Schema Privileges box is pretty useless. I have about 30 tables in my database and it appears the only way I can assign privileges to roles is to drag and drop them all for each role.

I would like to confirm this bug.

An additional note about this is that selecting multiple objects with the shift key and then dragging them into the Objects box only adds one object.

Without the ability to add an entire schema or multiple objects the Schema Privileges box is pretty useless. I have about 30 tables in my database and it appears the only way I can assign privileges to roles is to drag and drop them all for each role.

Duplicate of bug #54153