Qlik Sense section access

[#1]

Hello guys, I have a problem with Section Access in Qlik Sense server.

I have implemented section access for row level security as the below code shows:

Section Access;

LOAD * inline [

ACCESS, USERID

USER, xx\xx

USER, yy\yy

USER, zz\zz

];

section application;

Load * inline [

USERID, TL2

xx\xx, *

yy\yy, Cars

zz\zz, *

];

Now for user yy\yy, everything is as desired and is restricting the meta-data of column TL2 to "Cars" only.

However for xx\xx and zz\zz, the data should not be restricted but however when they open the report, there is absolutely no data.

The users are being authenticated but the data is completely absent.

When I change the * to any parameter, it works but * does not work.

Thanks in advance.

[jp_golay]

You can now test our new Product SAM that will fully automate Section Access Generation product.

It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.

A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .

Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, and Reverse Engineer existing section Access a time saving for simple cases.

More details on our website or contact me at jp.golay@ebiexperts.com