opensearch-project / opensearch-project/sql-odbc
[FEATURE] Request an option to inform the indices alias in the driver configuration
@seankao-az is already working on this.
Since Apr 8, 2024.
- Dominant language
- C++
- Stars
- 10
- Forks
- 25
- PR merge metrics
- No merged PRs in 30d
Description
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.