4 Replies Latest reply: Apr 24, 2018 3:14 AM by Sumanta Kumar Mandal RSS

    Section Access

    Louis Lam

      Hi All,

       

      We have a section access in app,

      There are two fields in section access, one is COMPANY_CODE, the other one is DIVISION_CODE.

      We have set the user sysadmin * in these two fileds so that sysadmin can access all data.

       

      But the result is some value is filtered out.

       

      Section Access;

      LOAD

          "USERID",

          "ACCESS",

          COMPANY_CODE,

          DIVISION_CODE

      FROM [lib://DEMO/User list.xlsx]

      (ooxml, embedded labels, table is Access);


      Is there any issue on the script and user list file?

       

      Best Regards,

      Louis

        • Re: Section Access
          Nagaian Krishnamoorthy

          The user id has to be in Capitals.

          For the access level specified in your Excel file, you do not need Section Access at all.

          • Re: Section Access
            Rahul Thakkar

            Hi Luis,

             

             

            With '*' in COMPANY_CODE and DIVISION_CODE user will be able to see all listed codes for other users. As you are having only ADMIN user currently, you can leave it blank instead of writing '*'.

             

             

            For example do check bottom example on this page - https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/Security/manage-security-with-section-access.htm

             

             

            Regards,

            Rahul

            • Re: Section Access
              Mark Little

              HI Louis,

               

              As Rahul suggest this is because of the use of '*', as you would expect this is wild card charater.

              But it will only give you access to any of the COMPANY_CODE or DIVISION_CODE that are used in your section access. One way to get around this to create a dummy user that have all the COMPANY_CODE's and DIVISION_CODE's listed in the access table


              Something like;


              Concatenate Section Access;


              LOAD Distinct

                  'Dummy'  as "USERID",

                  'User'      as  "ACCESS",

                  COMPANY_CODE,

                  DIVISION_CODE

              Resident 'Your table'

               

              you table being where the COMPANY_CODE and DIVISION_CODE are kept in your data. You may have to add more to the script if they are kept on different tables.


              Mark

              • Re: Section Access
                Sumanta Kumar Mandal

                Hi Louis,

                 

                Instead of writing '*' you can write all the list of company_code and division_code like:

                 

                ACCESS     USERID                         COMPANY_CODE     DIVISION_CODE

                ADMIN     DOMAIN\SYSADMIN          ABC                              EAST

                ADMIN     DOMAIN\SYSADMIN          DEF                              WEST

                ADMIN     DOMAIN\SYSADMIN          XYZ                              NORTH

                ADMIN     DOMAIN\SYSADMIN          PQR                              SOUTH