topic Re: Restrict access to database in qlik sense in Connectivity & Data Prep

Restrict access to database in qlik sense

tvisha — Fri, 10 Dec 2021 21:09:00 GMT

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,

Re: Restrict access to database in qlik sense

PadmaPriya — Fri, 18 Jun 2021 14:41:10 GMT

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-security-with-section-access.htm

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/Security/manage-security-with-section-access.htm?_ga=2.26367101.1757435000.1623761307-465855516.1600057328

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

Re: Restrict access to database in qlik sense

tvisha — Thu, 24 Jun 2021 10:19:04 GMT

Hi,

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

Thank You,

Re: Restrict access to database in qlik sense

Andre_Sostizzo — Wed, 25 Aug 2021 18:53:08 GMT

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