Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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://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
Feel free to check Managing data connections and extensions which may be of help.
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://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
Hi,
How do I restrict access to a connection, to the source database and set permissions on the connections. @PadmaPriya
Thank You,
Feel free to check Managing data connections and extensions which may be of help.