Bug #24887 Assigning privileges to views does not work

• Submitted: 7 Dec 2006 13:49
• Modified: 8 Dec 2006 9:27
• Reporter: Jasper Knockaert
• Status: Won't fix
• Category: MySQL Administrator
• Severity: S4 (Feature request)
• Version: 1.2.6rc
• OS: MacOS (Mac OS X 10.4.8 (Intel))
• CPU Architecture: Any
• Tags: object privileges

[7 Dec 2006 13:49] Jasper Knockaert

Description:
The GUI doesn't allow me to assign privileges to views.

How to repeat:
1) Open MySQL Administrator.
2) Set Preferences - Administrator to show object privileges settings
3) Choose the "Accounts" tab.
4) In the "Accounts" list select a user and a host
5) In the "Schemata" list select a view
6) Try to assign a privilege (which is not possible)

Suggested fix:
Make it work just as it works for tables.

[8 Dec 2006 8:23] Sveta Smirnova

Thank you for the report.

Do you mean you can not assign "Create View" and "Show view" priveleges?

[8 Dec 2006 9:05] Jasper Knockaert

No, I mean that the GUI does not provide an equivalent for e.g.
GRANT SELECT ON view_name TO user@host;

The GUI allows to assign privileges for databases,tables,columns but not for views.

Maybe it is not a bug but rather a feature request.

[8 Dec 2006 9:27] Sveta Smirnova

Thank you for the explanation.

Verified as feature request.

[13 Mar 2014 13:35] Omer Barnir

This bug is not scheduled to be fixed at this time.