topic How to limit oledb to a specific db in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-limit-oledb-to-a-specific-db/m-p/92212#M476 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 10 Oct 2018 14:01:11 GMT Anonymous 2018-10-10T14:01:11Z How to limit oledb to a specific db https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-limit-oledb-to-a-specific-db/m-p/92212#M476 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 10 Oct 2018 14:01:11 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-limit-oledb-to-a-specific-db/m-p/92212#M476 Anonymous 2018-10-10T14:01:11Z Re: How to limit oledb to a specific db https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-limit-oledb-to-a-specific-db/m-p/1869418#M9976 <P>I did not find any solution in Qlik Sense OLE DB connector settings.&nbsp; 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.</P> Sat, 11 Dec 2021 21:31:50 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-limit-oledb-to-a-specific-db/m-p/1869418#M9976 StefanBuchta 2021-12-11T21:31:50Z