Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marcoyukon
Contributor

Need help with Row Level Security on Qlik Sense.

How do I pass the authenticated windows AD user name to a Qlik Sense app and filter the data only to that user or AD group ?

Regards,

Marco

4 Replies
mov
Esteemed Contributor III

Re: Need help with Row Level Security on Qlik Sense.

rittermd
Honored Contributor

Re: Need help with Row Level Security on Qlik Sense.

You would need to setup Section Access.  There is a specific format you need to use to insert this logic into your apps.

You load your section access data either through an inline table or from a file.

The format is

ACCESS USERID fieldname

ACCESS can be either USER or ADMIN

USERID is the domain\AD userlogin

fieldname is the field that you want to limit access by(for example Branch #)

So each row in your data would look something like this:

USER  domain\userid  50

This would allow this user to see data for branch 50

marcoyukon
Contributor

Re: Need help with Row Level Security on Qlik Sense.

Will give it a try, thanks.

Not applicable

Re: Need help with Row Level Security on Qlik Sense.

This turned out to be easier than I thought. In Qlik Sense terms this is referred as "Dynamic Data Reduction". You can setup horizontal (REDUCTION) or vertical (OMIT) security by using session access in your data load script.

https://help.qlik.com/en-US/sense/2.1/Subsystems/Hub/Content/Scripting/Security/dynamic-data-reducti...

Community Browser