Bug #14114 displayed assigned privileges for a user are not correct
Submitted: 18 Oct 2005 13:27 Modified: 11 Jan 2006 9:18
Reporter: Fredrik Richtnér Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.3 OS:Windows (windows)
Assigned to: Mike Lischke CPU Architecture:Any

[18 Oct 2005 13:27] Fredrik Richtnér 
Description:
MySQL Administrator 1.1.3 is connected locally to MySQL 5.0.13 running on Windows XP Professional with Service Pack 2.

I use the command line tool mysql to connect to MySQL 5.0.13. I connect as user "root".

I create a new user and assign privileges:
mysql>
mysql> grant select,insert,update,delete,create,drop,index,alter,create routine,
alter routine,execute on test.* to 'testuser'@'localhost' identified by 'testuser';
Query OK, 0 rows affected (0.00 sec)

I show the newly created user and privilges:
mysql>
mysql> show grants for testuser@localhost\G
*************************** 1. row ***************************
Grants for testuser@localhost: GRANT USAGE ON *.* TO 'testuser'@'localhost' IDEN
TIFIED BY PASSWORD '*3A2EB9C80F7239A4DE3933AE266DB76A7846BCB8'
*************************** 2. row ***************************
Grants for testuser@localhost: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `test`.* TO 'testuser'@'localhost'
2 rows in set (0.00 sec)

I now open Administrator to see the same information. I select "User Administration", select the user "testuser", select tab "Schema Privileges" and select database "test".

Privilege "EXECUTE" is missing from the list of "Assigned Privileges". All other privilges are correctly displayed.

How to repeat:
See description.
[20 Oct 2005 9:00] Vasily Kishkin 
I was able to reproduce the bug. Screen copy is attached.
[20 Oct 2005 9:00] Vasily Kishkin 
screen copy

Attachment: 14114.GIF (image/gif, text), 102.43 KiB.
[11 Jan 2006 9:18] Mike Lischke 
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