MySQL Bugs: #66381: Improved User Privilege Functions and Information Display

Bug #66381	Improved User Privilege Functions and Information Display
Submitted:	14 Aug 2012 16:30	Modified:	15 Aug 2012 19:55
Reporter:	Anil Natha	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S4 (Feature request)
Version:	5.2.42	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	Administration, grant, privileges, Security, users

Description:
The 'Users and Privileges' functionality is lacking the ability to add/edit and display a user's privileges at table levels.  This makes the tool inefficient to use in an Administrative capacity when adding new or editing existing users as a DBA must then rely on writing their own grant statements and executing them outside of the Administration area.

How to repeat:
Visit the 'Users and Privileges" section in the Administration area of a Database and you will see that the table privilege features missing.

Suggested fix:
Add the ability for a DBA to not only select which schema a user can access, but also which tables and what Object Rights they have on those tables.

In addition, if possible, add the other missing features that are available via Grant as documented here: http://dev.mysql.com/doc/refman/5.5/en/grant.html#grant-table-privileges and for all the other versions of MySQL.

Forgot to note that I am on OS X.

Hello Anil,
Can you please check the Server Access Management and Schema Privileges sections?, you will find what you need there.

Hi Rafael,

The area you mentioned is the same area I was referring to in my original comment.

I do not see anywhere in there you can specify table privileges.  At the present time, I only see the ability to specify schema privileges within workbench.  Using the grant statement, you can restrict access to a user to have certain object rights per table, not just per schema.  This is the granularity I was referring to in my original comment that I felt is lacking in the administration area.

Duplicated of Bug #55224