MySQL Bugs: #49912: Acct usability changes to admin roles list

Bug #49912	Acct usability changes to admin roles list
Submitted:	24 Dec 2009 16:33	Modified:	25 Dec 2009 9:38
Reporter:	Mike Frank	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.11	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Accounts/Administrative Roles Screen

Need usability changes to list in suggested fix

How to repeat:
go to Accounts/Administrative Roles Screen

Suggested fix:
I have 2 suggestions for this. 
1) Order such the superior is above subordiate co-role -- Sec Admin above user admin 

2) Make the the check box greyed out and selected --  so it can't be clicked or unclicked unless superior is deselected.

Thank you for the feature request.

For what is Sec Admin at all?

Create a super user directly on the system:

GRANT ALL on *.* TO myuser@'myhost' WITH GRANT OPTION;

This should mark the user in Workbench as Sec Admin. But Sec Admin isn't marked. It is not marked on any super user.

So for what the hell is that role?

Same with the role DBA.

"grants the right to perform all tasks"

Isn't that exactly what a super user is? Why isn't it marked on super users?

These roles aren't compatible with MySQL server at all.

It is very confusing and I am not able to see the sense at all.

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.