2 Replies Latest reply: Dec 13, 2017 3:38 PM by Patrice Tremblay RSS

    Managing security with Access section in Qlik Sense

    Patrice Tremblay

      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

        • Re: Managing security with Access section in Qlik Sense
          S Khan

          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.