topic Re: Managing security with Access section in Qlik Sense in App Development

Managing security with Access section in Qlik Sense

patt-big-data — Wed, 13 Dec 2017 14:48:15 GMT

i have some questions concerning managing security with ACCESS section :

i want to give access to users depending on the
value given for a group made of the concatanation of 2 fields.

I want give access to a user that have for
example : For Qlik2, the value of EXT or INT field equal to 33 OR 10.

Here is my exemple -->

Section Access :

Section Application : (QVD)

Table-test:
Seq. No. XXXXXXX       Ext Int   EXT_INT*
       1   99 YYYYYYYYYY 42   18    42|18
       2   99 YYYYYYYYYY 51 23    51|23
       3   99 YYYYYYYYYY 63 51    63|51
       4   99 YYYYYYYYYY 66 11    66|11
       5   99 YYYYYYYYYY 12 21    12|21
       6   99 YYYYYYYYYY 10 11    10|11
       7   99 YYYYYYYYYY 51 77    51|77
       8   99 YYYYYYYYYY 66 32    66|32

* : The last column is a concatenation of fields EXT and INT

This is what i would like :

I want user Qlik1 to have access to every record of Table-test (1 to 😎

I want user Qlik2 to have access to record 6
I want user Qlik3 to have access to record 1, 2, 3 and 7
I want user Qlik4 to have no access
I want user Qlik5 to have access to record 2, 3 et 7

Re: Managing security with Access section in Qlik Sense

MK9885 — Wed, 13 Dec 2017 20:13:13 GMT

Star is *;

Section Access :

LOAD * INLINE [
ACCESS, USERID, EXT_INT

    ADMIN,INTERNAL\sa_scheduler,*
    USER, DomainName\Qlik1, *
    USER, DomainName\Qlik2, 33|10
    USER, DomainName\Qlik3, 51|18
    USER, DomainName\Qlik4, 76|76
    USER, DomainName\Qlik5, 51|51
];

Section Application;

You may need INTERNAL\sa_scheduler as thru this account your applications gets loaded in QMC, it is a service account.

DomainName\Qlik1 is required as it would look NTname of the users (to check NtName , type in =osusers() in a text box)

In case you get locked from your app, right click on app and click 'Open without data' to modify the script.

* will give access to all the fields in EXT_INT

Plus move this question to 'New to Qlik Sense' to get more answers.

Re: Managing security with Access section in Qlik Sense

patt-big-data — Wed, 13 Dec 2017 20:38:32 GMT

I did not include the domain name in my example

for clarity purpose.

Thanks