Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

patt-big-data
New Contributor

Managing security with Access section in Qlik Sense

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 :

LOAD * INLINE [
    ACCESS, USERID,  EXT_INT
    USER,  Qlik1,  *|*
    USER,  Qlik2,  33|10
    USER,  Qlik3,  51|18
    USER, Qlik4,  76|76
    USER,  Qlik5,  51|51
]=
where 1=1;

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 8)

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

2 Replies
Khan_Mohammed
Honored Contributor II

Re: Managing security with Access section in Qlik Sense

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;

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

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.

patt-big-data
New Contributor

Re: Managing security with Access section in Qlik Sense

I did not include the domain name in my example

for clarity purpose.

Thanks

Community Browser