5 Replies Latest reply: Jul 16, 2015 1:36 PM by Stefan Wühl RSS

    Section Access with *

      Hi,

       

      I'm trying to use section access but I don't succeed. I have a simple doc where I use an inline table adding ACCES, NTNAME and DEPARTMENT fields. It is supposed to login automatically recognizing the domain and username and do a reduction by DEPARTMENT.

       

      The thing is that it works when I filter for a specific department, but it doesn't when I try to use the *. It is supposed that using the * and adding other values on the same column (DEPARTMENT in my case) * should represent all listed values. But when I use it it doesn't allow me to open the doc.

       

      I am really stucked on it and I can't find why it is not working as other examples I've found, this one for exampleQlikView Section Access Examples

       

      That's the script I use. Many thanks in advance.

       

       

      DEP:

      load* Inline

      [Name, DEPARTMENT

      A,ABC

      B,XYZ

      C,BNH

      D,JHK

      E,LKJ

      F,OLP

      ];

       

      section_access:

      load * inline [

      ACCESS, NTNAME, DEPARTMENT

      USER, domain\RUBEN.GRAU, *

      USER, domain\someone, ABC

      ];

       

      STAR is *;

       

      SECTION ACCESS;

      LOAD

          ACCESS,

          NTNAME,

          DEPARTMENT

      RESIDENT section_access;

        

      SECTION APPLICATION;

      STAR is;

        • Re: Section Access with *
          Gysbert Wassenaar
          * should represent all listed values

          That's right and in the below table only ABC is listed:

          sectionaccess_tmp:

          load * inline [

          ACCESS, NTNAME, DEPARTMENT

          USER, domain\RUBEN.GRAU, *

          USER, domain\someone, ABC

          ];

          So RUBEN.GRAU will only have access to department ABC

          • Re: Section Access with *
            Krishna Chaitanya

            PSA.

            hope that helps.

            Use below Ids and pswrds to see their respective data.

             

            ACCESS ,NAME               ,PASSWORD       ,DEPARTMENT

            ADMIN   ,RUBEN.GRAU   ,RUBEN.GRAU    , *

            USER    ,A                        ,A                         , ABC

            USER    ,B                        ,B                         , XYZ

            USER   ,SOMEONE          ,SOMEONE           , *

             

            Thanks

            • Re: Section Access with *
              Massimo Grossi

              in my test it works (*) but not with section access loaded from resident

               

              DEP:

              load* Inline

              [Name, DEPARTMENT

              A,ABC

              B,XYZ

              C,BNH

              D,JHK

              E,LKJ

              F,OLP

              ];

               

              //section_access:

              //load * inline [

              //ACCESS, NTNAME, DEPARTMENT

              //USER, domain\RUBEN.GRAU, *

              //USER, domain\someone, ABC

              //USER, mydomain\myuser, ABC

              //];

               

              SECTION ACCESS;

              //STAR is *;

              load * inline [

              ACCESS, NTNAME, DEPARTMENT

              USER, domain\RUBEN.GRAU, *

              USER, domain\someone, ABC

              USER, domain\someone2, XYZ

              USER, mydomain\myuser, *

              ];

              //LOAD

              //    ACCESS,

              //    NTNAME,

              //    DEPARTMENT

              //RESIDENT section_access;

               

              SECTION APPLICATION;

              //STAR is;

              • Re: Section Access with *
                Stefan Wühl

                If your user gets access denied, you probably have strict exclusion enabled.

                 

                I think what's missing is a

                 

                drop table section_access;

                 

                at the end of your script. If you don't drop the table, you will get into troubles on opening.