3 Replies Latest reply: Jan 10, 2012 5:52 AM by Miguel Angel Baeyens de Arce RSS

    Simulation of a user login

    Frédéric Villemin

      Hi,

       

      i'm using QV Server 10 R4 and the Active Directory authentification.

       

      I have some problems with users which cannot see some secured documents.

       

      Is it possible, as administrator, to simulate an access on AccessPoint and on documents with their AD credentials ?

       

      Thanks

        • Simulation of a user login
          Miguel Angel Baeyens de Arce

          Hi Frédéric,

           

          Since authentication is done by the AD, you cannot connect see their data unless you know their username and passwords.

           

          But what you do can do is to set in section access the USERID and PASSWORD instead of NTNAME with the same REDUCTION field as thay would have. This will work not only for information reduction (called authorization) but for permissions (go to the Settings menu in QlikView, Document Properties, Server tab and click "Filter AccessPoint Document List Based On Section Access").

           

          Anyway, if you need to check whether NTFS permissions are working fine to use the documents, you will need to use their credentials in any case.

           

          Hope that helps.

           

          Miguel

            • Simulation of a user login
              Frédéric Villemin

              Thanks for your answer Miguel :

               

              can you confirm me the type of section access i can use ?

               

              ADD LOAD * INLINE [

              ACCESS,                    NTNAME, USERID, PASSWORD, TYPEACCESS

              USER,                    AD\XXXX, , , TYPE0

              USER, , XXXX, PASSWORDXXXX, TYPE0

              ];

               

              Should that work ??

                • Re: Simulation of a user login
                  Miguel Angel Baeyens de Arce

                  Hi,

                   

                  Use "*" instead of blanks in all fields, just in case Make sure you back up your file before changing and reloading section access, in case you lock yourself out. (Or uncheck the "Strict exclusion" un the Settings, Document Properties, Opening tab). This example works. If the accessing user is neither DOMAIN\USER1 nor DOMAIN\USER2 it will prompt for user and password. If User1 or User2 are entered, with their corresponding passwords, they will be granted access.

                   

                  SECTION ACCESS;
                  
                  LOAD * INLINE [
                  ACCESS, NTNAME, USERID, PASSWORD, TYPE
                  USER, DOMAIN\USER1, *, *, 1111
                  USER, *, USER1, USER1, 1111
                  USER, DOMAIN\USER2, *, *, 2222
                  USER, *, USER2, USER2, 2222
                  ];
                  
                  SECTION APPLICATION;
                  
                  DATA:
                  LOAD * INLINE [
                  TYPE, VALUE
                  1111, AAAA
                  2222, BBBB
                  ];
                  

                   

                  Hope that gives you the idea

                   

                  Miguel