Is it possible to restrict which "Database" to load data from after a database connection is made?

[jblomqvist]

Hi,

Is it possible to restrict which databases to load data from after a database connection is made?

For example once you make a SQL Server data connection and click "select data" it's this option:

Is it possible to restrict which values a user can select from this drop-down list?

[agni_gold]

for this, you need to add different data connections.

While an alternate way is to keep one configuration excel where you store your connection string something like below and call in your script : 

OLDEDB CONNECT TO 

[Provider=SQLOLEDB.1;
Persist Security Info=True;
User ID=UserID;
Initial Catalog=DataBaseName;
Data Source=DatabaseHostName/IP;
Use Procedure for Prepare=1;
Auto Translate=True;
Packet Size=4096;
WorkstationID=QlikSenseServerHostName;
Use Encryption for Data=False;
Password = YourPassword;
Tag with column collation when possible=False] ;

[anderseriksson]

Access to different databases you restrict in the database server.
You need different accounts for the different databases and the configure different connections in Sense.