Bug #13591 Program quits when trying to grant table level privileges
Submitted: 29 Sep 2005 2:11 Modified: 3 Dec 2005 2:53
Reporter: Franklin Parlamis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.0 OS:MacOS (Mac OS X 10.4.2)
Assigned to: CPU Architecture:Any

[29 Sep 2005 2:11] Franklin Parlamis 
Description:
Tried to set table level privileges for user "someuser@localhost".  Program quits when table is selected.  

Opened program.  Clicked on "Accounts" tab.  Selected account "someuser@localhost" from Accounts column.  Clicked on "Table Privileges" tab.  Under column "Schemata" chose the "test_someword" database I had created and clicked triangle to expand tables.  Clicked on table "sometable".  Program quit immediately.

(Note:  I have used someuser, sometable and someword as space fillers, but my actual database name syntax starts with "test_")

How to repeat:
Repeat steps above.  

Suggested fix:
Perhaps related to global grant (in "db" table of database "mysql") of all privileges to all users in databases with names that match pattern "test\_*".  This renders table-level privileges moot.  However, program should not quit, maybe issue a warning or courtesy message?
[29 Sep 2005 14:40] Jorge del Conde 
Thanks for your bug report.  I was able to see the same results under 10.4
[3 Dec 2005 2:53] Alfredo Kojima 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html