Connector Lists Too Many Databases

RaBe · April 12, 2022, 5:39am

In the Query Database dialogue connectors list every table in each database the database user has the right to see, not only the one DB defined in the connector. So the Database name field in the connector dialogue doesn’t do anything currently.

dgudkov · April 12, 2022, 6:43am

What is the database type/connector?

Can you post screenshots of the connector settings and the list of tables in the Query Editor that you see?

RaBe · April 12, 2022, 7:04am

Hi Dmitri,

Thanks for your quick reply. Below are the requested screen shots.

andrew.rybka · April 13, 2022, 9:27pm

Hi @RaBe,

It works correctly on my side.

Are you sure that “CoreDB_Admin” and “CoreDB_DEV” are databases and not schemas?

RaBe · April 14, 2022, 5:16am

MariaDB does not have schemas. So it’s not DB.Schema.Table but DB.Table.

andrew.rybka · April 14, 2022, 8:23am

Sorry, my bad.

The Database name field of the MariaDB allows you to specify the default database for the connection.

If you want to remove some of the databases from the tables lists, you should use the “Schemas” tab of the connector properties:

For databases that don’t have schemas, that filter is applied to database names.