Bug #99755 Schema Navigator Empty without SHOW DATABASES Grant

• Submitted: 1 Jun 2020 19:40
• Modified: 1 Jun 2020 20:30
• Reporter: Ronald Giesman
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.18 Build 15329599
• OS: Windows (Microsoft Windows 10 Enterprise)
• CPU Architecture: x86
• Tags: WBBugReporter

[1 Jun 2020 19:40] Ronald Giesman

Description:
Schema navigator will not show objects within the configured default schema without the 'SHOW DATABASES' privilege; our database security team will not allow this grant on the database.  The user has all other necessary grants to the default schema, just not 'SHOW DATABASES'.

How to repeat:
Connect to any MySQL instance and authenticate as a user without 'SHOW DATABASES' privilege.  The Schema navigator object pane will be blank and you will get error 1227: "Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation".

Suggested fix:
Allow the schema navigator object tree to populate with objects from the configured default schema without SHOW DATABASES grant.

[1 Jun 2020 19:44] Ronald Giesman

Moved build info from CPU Architecture details field to Version

[1 Jun 2020 20:30] MySQL Verification Team

Thank you for the bug report. This is a server privileges restriction and WorkBench behaves like another client.

https://dev.mysql.com/doc/refman/8.0/en/show-databases.html