Bug #16245 "Execute " permissions not been assigned using the MySql Administrator
Submitted: 6 Jan 2006 6:31 Modified: 7 Jul 2006 13:40
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.1.6, 1.1.5 OS:Windows (Windows XP)
Assigned to: Mike Lischke CPU Architecture:Any

[6 Jan 2006 6:31] [ name withheld ]
Description:
There is a bug in MySql Administartor 1.1.5  
If we create user using it , then execute Permissions in never gets  assigned .
Even if it the soul permission that you want to assign .
This also happens even if u assign all the Privileges avaliable .

How to repeat:
create a new user using the MySql Administartor 1.1.5  with folloing details

user name = 'sa'
password = 'tiger' 

then it the " User Administration " wizard , click the  " Schema Privileges " Tab .
Select any database avaliable in the " Schemata " List . ( for e.g say " Dms " database was selected )
In the " Avaliable Privileges " List , there is a permission " Execute " .
Assign this permission using " < " tab , to the database selected .

Click " Apply changes " button at the bottom of the screen .

Refresh the user account .

select the  database for which the permissions were assinged to the user account "sa"
. The   "execute " permissions is not shown in the "Avaliable Privileges " List .

Same thing happens even if , all permissions are assigned .
Even then the "Execute" permission is not seen in the " Avaliable Privileges " List .
[6 Jan 2006 13:21] Valeriy Kravchuk
Thank you for a bug report. Verified just as described with MySQL Administrator 1.1.6.
[7 Jul 2006 13:40] Mike Lischke
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/