Bug #55186 Missing privilege when assigning role

• Submitted: 12 Jul 2010 19:39
• Modified: 2 Sep 2010 16:54
• Reporter: al gelders
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.25
• OS: Any
• Assigned to: Mike Lischke
• CPU Architecture: Any

[12 Jul 2010 19:39] al gelders

Description:
Unable to add 'LOCK TABLES' privilege

How to repeat:
Add role and table.  Desired privilege not in list.

Suggested fix:
Add to list or add check box so user can add missing privilege in case others are not on list.

[13 Jul 2010 2:23] MySQL Verification Team

Please see in Schema Privileges -> Other Rights. Thanks in advance.

[13 Jul 2010 4:17] al gelders

Unable to locate Schema Privileges -> Other Rights selection in workbench

[13 Jul 2010 5:53] Valeriy Kravchuk

Indeed, LOCK TABLES privilege is not available in role definition tab. Verified on Mac OS X.

[3 Aug 2010 12:27] Mike Lischke

Fixed in repository

[25 Aug 2010 17:08] Johannes Taxacher

fix confirmed in repository

[2 Sep 2010 16:54] Tony Bedford

An entry has been added to the 5.2.27 changelog:

It was not possible to add LOCK TABLES privilege when assigning a new role in the Model Overview, as that privilege was missing from the available options.