topic Is it possible to restrict which databases to load data from after a database connection is made? in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Is-it-possible-to-restrict-which-databases-to-load-data-from/m-p/1747251#M5426 <P>Hi,</P><P>Is it possible to restrict which databases to load data from after a database connection is made?</P><P>For example once you make a SQL Server data connection and click "select data" it's this option:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jblomqvist_0-1601047038302.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/41233i32022C7ECD6CA58C/image-size/medium?v=v2&amp;px=400" role="button" title="jblomqvist_0-1601047038302.png" alt="jblomqvist_0-1601047038302.png" /></span></P><P>Is it possible to restrict which values a user can select from this drop-down list?</P> Fri, 10 Dec 2021 20:26:56 GMT jblomqvist 2021-12-10T20:26:56Z Is it possible to restrict which databases to load data from after a database connection is made? https://community.qlik.com/t5/Connectivity-Data-Prep/Is-it-possible-to-restrict-which-databases-to-load-data-from/m-p/1747251#M5426 <P>Hi,</P><P>Is it possible to restrict which databases to load data from after a database connection is made?</P><P>For example once you make a SQL Server data connection and click "select data" it's this option:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jblomqvist_0-1601047038302.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/41233i32022C7ECD6CA58C/image-size/medium?v=v2&amp;px=400" role="button" title="jblomqvist_0-1601047038302.png" alt="jblomqvist_0-1601047038302.png" /></span></P><P>Is it possible to restrict which values a user can select from this drop-down list?</P> Fri, 10 Dec 2021 20:26:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Is-it-possible-to-restrict-which-databases-to-load-data-from/m-p/1747251#M5426 jblomqvist 2021-12-10T20:26:56Z Re: Is it possible to restrict which databases to load data from after a database connection is made https://community.qlik.com/t5/Connectivity-Data-Prep/Is-it-possible-to-restrict-which-databases-to-load-data-from/m-p/1747457#M5430 <P>Hi, I haven't done that but I think it should be configured on the SQL Server side, giving or removing read permission to the users on each database.</P> Sun, 27 Sep 2020 08:44:47 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Is-it-possible-to-restrict-which-databases-to-load-data-from/m-p/1747457#M5430 rubenmarin 2020-09-27T08:44:47Z