Restrict access to database in qlik sense

[tvisha]

How do I restrict data access and creating database objects by all users. I am using OLEDB connection and the using windows authentication.

The user does not have access to the database, but is still able to connect to the datasource.

How can I restrict the same.

Thanks, 

[PadmaPriya · Accepted solution]

Hello @tvisha 

If you want to restrict access of developers of Qlik Sense apps to source database tables then you need to create several connections to the source database and set permissions on the connections. If you want to restrict access to data in apps for different users then you can use section access in the apps. Or perhaps create different front end apps for the different groups of users and load only the data they're allowed to access in those front end apps.

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage...

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/Security/manage-secu...

https://support.qlik.com/articles/000006878

If you want to restrict the right to create new connections you need to modify the security rule "Data Connection". Fir example you can modify the rule as:

((resource.type!="folder") and (user.roles="DataAdmin"))

This rule creates also a new role called "DataAdmin and grant only to the users with this role to create new Connections.

Thanks,

Padma Priya

Qlik Support

[tvisha]

Hi,

How do I restrict access to a connection, to the source database and set permissions on the connections.  @PadmaPriya 

Thank You,

[Andre_Sostizzo · Accepted solution]

Feel free to check Managing data connections and extensions which may be of help.