Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
raoballakur
New Contributor II

Question of Database table access restriction via Qlik Sense

Question on User Authorization.  Is there a way I can enable only a set of tables for a database connection using qlik sense data connector? In other words, is there a way Qlik Sense will help in whitelisting a set of tables for a Database connection based on the logged in user? I wanted to restrict a set of user from accessing tables that they are not supposed to see for a given database connection when they are trying to load data and create reports.


I don't want to create a database user id for each set of users and control the access of the tables in the Database.



1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Question of Database table access restriction via Qlik Sense

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.


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Question of Database table access restriction via Qlik Sense

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.


talk is cheap, supply exceeds demand
raoballakur
New Contributor II

Re: Question of Database table access restriction via Qlik Sense

Thanks gysbert. How exactly do I set permissions on the connector to allow access to a set of tables? I do not see any options when I edit the connection nor in QMC. All I can do is have a set of security rules to dictate who can access the data connection.

MVP & Luminary
MVP & Luminary

Re: Question of Database table access restriction via Qlik Sense

Yes, that's how you do it. Specify which database user should be used to connect with the database. Authorize that user in the database for only the tables that should accessed. Define security rules for the connection.


talk is cheap, supply exceeds demand
raoballakur
New Contributor II

Re: Question of Database table access restriction via Qlik Sense

Well, that would mean that I need to create different database user ids which have the required restriction and different qlik sense connections will use different db user ids. But this is something that I wanted to avoid.