MySQL Bugs: #25094: hard to change privileges on schema wildcard

Bug #25094	hard to change privileges on schema wildcard
Submitted:	15 Dec 2006 14:26	Modified:	30 Jan 2007 19:27
Reporter:	Yahoo Serious (Silver Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.6	OS:	Windows (Windows 2000 SP4)
Assigned to:	Peter Lavin	CPU Architecture:	Any

Description:
I did not succeed in adding GRANTS (privileges) on a wild card for schema names.  Now I finally found out how to do it:
- go to User Administration
- select a user
- go to tab schema privileges
(pretty intuitive so far)
- right click on the schema list and select "Add schema with wildcards"

I think this last step is too hidden for most

How to repeat:
Try adding privileges on a wild card for schema names, without reading the above :-)

Suggested fix:
So I have some requests:
  a) document this now,
and/or
  b) change this (now or later), by either (in my preference order):
 - adding a "wild card schema name edit box"
 - adding the ability to always enter a wild card in the existing "schema name edit box"
 - adding a "wild card schema name check box", to enable adding wild cards in the existing "schema name edit box"
 - also add the right click to the schema name edit box

Changed to S3 as it is more a lack of accessibility than a new feature.

Thank you for the bug report.

Added a note about escaping wild cards when they are part of a database name.