We have a QLIK Sense server that we connect to MS SQL server via ole db. Is there a way to configure things those that a specific named connection can only see a specific database on the targeted server? We want to restrict a group of users to only a specific database and not all databases on the server. (uses windows authentication/service account we read-only access to all production dbs, but we have a need to restrict it further.
I did not find any solution in Qlik Sense OLE DB connector settings. Therefore, I had to create a dedicated local db account for each MS SQL database. Subsequently, I created a separate OLE DB data connection with a specific user name and password option for each local db account and MS SQL DB separately. It works fine for me.
