Need help with Row Level Security on Qlik Sense.

[marcoyukon]

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

[Anonymous]

Looks like you have to use Section Access

Qlik Sense Security integration - Security Rules and Section Access

[rittermd]

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]

Will give it a try, thanks.

[#5]

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...