Bug #79103 Missing schema privilege: "SHOW VIEW"

• Submitted: 3 Nov 2015 22:57
• Modified: 7 Mar 2018 12:53
• Reporter: carim manzur
• Status: No Feedback
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: 6.3.5
• OS: Any
• CPU Architecture: Any
• Tags: EER model, privileges, schema

[3 Nov 2015 22:57] carim manzur

Description:
In EER model, Schema Privileges tab:
When I try to add a ROLE, the "SHOW VIEW" privilege is missing.

How to repeat:
1 Open workbench 6.3.5
2 Click on the PLUS icon, which creates a new EER model.
3 In 'Model Overview' tab, 'Schema Privileges' accordion, click on: ADD ROLE
4 In the botton box, clic on 'privileges' sub-tab.
5 Right clic: add any Schema, add any schema wilcard.
6 The following privileges do not exist: SHOW VIEW, EXECUTE

Suggested fix:
1 Add the following privileges: SHOW, EXECUTE
2 Verify if others privileges are missing

[7 Feb 2018 12:53] MySQL Verification Team

Hello carim manzur,

Thank you for the feature request.
I tried to follow your steps but observed that SHOW VIEW is available in the 'privileges' tab of the VIEW. Could you please confirm with latest WB release and provide us exact screenshot from your environment? Thank you!

Thanks,
Umesh

[8 Mar 2018 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".