Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
patt-big-data
Contributor
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 😎

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
MK9885
Master II
Master II

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
Contributor
Contributor
Author

I did not include the domain name in my example

for clarity purpose.

Thanks