opensearch-project / sql-odbc

OpenSearchODBC is a read-only ODBC driver for Windows and Mac for connecting to OpenSearch SQL support.
Apache License 2.0
7 stars 17 forks source link

[FEATURE] Request an option to inform the indices alias in the driver configuration #66

Open quesmues opened 7 months ago

quesmues commented 7 months ago

Hello, I would like to report an issue we are having, the users who not being allowed to view all OpenSearch indices ("indices:admin/get") are getting an error to connect. Our OpenSearch users can only view their indexes, as the same server is shared between several projects so we cannot give permissions to view all indexes for security reasons.

A solution to this problem would be to add a option to inform the alias of the indices we want to connect, especially when the driver executing SHOW TABLES LIKE '%' in the connection test to the db, since we cannot directly execute this SQL because the lack of the "indices:admin/get".

Only to reinforce the idea, we can't add the permission to our users.