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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S4 (Feature request)
Version:5.2.31 CE Rev 7115 OS:Any
Assigned to: CPU Architecture:Any
Tags: Administration, feature request, privilages, workbench

[5 May 2011 6:27] Matt Cotterell
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!


How to repeat:

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