Bug #61066 Feature Request: Table, Proceedure and Column privilages in Workbench

• Submitted: 5 May 2011 6:27
• Modified: 10 May 2011 3:43
• Reporter: Matt Cotterell
• Status: Verified
• Category: MySQL Workbench: Administration
• Severity: S4 (Feature request)
• Version: 5.2.31 CE Rev 7115
• OS: Any
• CPU Architecture: Any
• Tags: Administration, feature request, privilages, workbench

[5 May 2011 6:27] Matt Cotterell

Description:
The Administration section of the MySQL Workbench has supported setting schema privilages on a per-user basis, but does not support setting privilages on a column or table based perspective. While it is possible to simply add these via SQL commands, behaviour of the GUI might omit these entries, so from a security perspective some administrators may miss critical permissions that should have been revoked or conflict with the configuration they are aiming for.

Is it possible to add these in with a new release? Any input or ideas is appreciated!

Matt

How to repeat:
N/A

Suggested fix:
Could be achieved by either creating a new tab in the GUI for each of these categories (and function similar to the current schema one) or add functionality to the schema panel that allows us to filter for tables (such as through a special character, such as "schema:table:column" or "schema#proceedure").

[10 May 2011 3:43] Valeriy Kravchuk

Thank you for the feature request.

[27 Apr 2017 12:36] MySQL Verification Team

Bug #86107 marked as duplicate of this one