Bug #52041 Incomplete View Privilege Support
Submitted: 14 Mar 2010 5:31 Modified: 1 Apr 2010 19:43
Reporter: Hameer Abbasi Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.16, 5.1.18 OS:Any (Cannot assign priveleges to a view)
Assigned to: Assigned Account CPU Architecture:Any
Tags: alter, create, delete, Drop, SELECT, UPDATE, VIEW, workbench

[14 Mar 2010 5:31] Hameer Abbasi
Description:
In MySQL Workbench (latest, both 5.2.16 and 5.1.18), it is impossible to assign view privileges for the functions SELECT, CREATE, DROP, ALTER, DELETE and UPDATE. The server I'm using is 5.1.44 (community). In the roles panel, only CREATE VIEW, SHOW VIEW and ALL show up.

How to repeat:
1. Open MySQL Workbench
2. Create a few tables and a view
3. Create a role
4. Try to assign privileges to the role for a view.

Suggested fix:
Add options to assign privileges for SELECT, CREATE, DROP, ALTER, DELETE and UPDATE for views.
[16 Mar 2010 11:01] Valeriy Kravchuk
I do not see any way in Workbench to set object level privileges neither for views nor for tables (I can grant SELECT on all objects in specific schema, but NOT to specific table t1 or view v1). Do I miss something?
[17 Mar 2010 4:22] Hameer Abbasi
You can add SELECT privileges to tables, but not to views.
[26 Mar 2010 12:41] Susanne Ebrecht
I am also not able to follow you.

Please describe it step by step.
[26 Mar 2010 17:50] Hameer Abbasi
All you have to do is, in workbench:

1. Create a table, and a view that uses it
2. Create a role
3. Double-click the role
4. Drag the view into the role's objects
5. Click the view's name in the objects pane
6. the only privileges you can see are ALL, CREATE VIEW, and SHOW VIEW. There should be options for update, alter, delete, drop, create, select.
[26 Mar 2010 17:51] Hameer Abbasi
Also, the ability to remove objects from roles is missing
[1 Apr 2010 19:43] Johannes Taxacher
this is a duplicate of Bug# 42157