#11334: Can't access MySQL database tables in tree if have not SHOW DATABASES privilege on server

Hubbitus reported 2014-01-12T16:29:29Z · last modified 2014-06-29T17:56:27Z

Can't access MySQL database tables in tree if have not SHOW DATABASES privilege on server

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Schema Browser
Version	15.0

Hi.

Please look at screenshot.

It is access to shared hosting server database where I indeed have access only to my database. And its specified in server connection properties.

As you also see I can then execute queries to it and get results. So, in case when you get Access denied for SHOW DATABASE, please implement fallback to list only configured database in object tree.

1 attachment

AquaDataStudioBugMysqlDatabaseTree.png

2014-01-12T16:29:29Z

123 KB

All Comments (2) Change History

JennyNishimura 2014-01-16T20:08:36Z

Updated the schema browser code to list only the registered database if MySQL returns error 1227 (access denied).

raghavsingh 2014-04-14T11:53:05Z

Verified in ADS15.0.0-dev-227

Search Tips

Aqua Data Studio / nhilam

Can't access MySQL database tables in tree if have not SHOW DATABASES privilege on server

1 attachment

Issue #11334

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Can't access MySQL database tables in tree if have not SHOW DATABASES privilege on server

1 attachment

Issue #11334

Completion