5 Replies Latest reply: Sep 27, 2010 11:45 AM by Miguel Angel Baeyens de Arce RSS

    Security Access

    Tiziana Caem

      Hello everyone.
      I have a problem with the Access Security.
      I load an external sheet xls in the Section Access, where I declare that NTNAME = user1 can only see Sheet1.

      If I open the document in local client, and I introduce myself as User1, I correctly see only Sheet1.
      If i public the document on the server , and i log on the web as a User1 I see all the sheets, not just one.

      Any ideas, please?

      Thanks

      Tiziana

        • Security Access
          Miguel Angel Baeyens de Arce

          Hello Tiziana,

          Bear in mind that NTNAME is the name of your user in Windows Active Directory, so you are not likely asked for username and password, as QlikView read them from your current logon.

          In your document try changing NTNAME by QVUser(), so QVUser() should be equal to "User1" when you log in.

          Hope that helps

            • Security Access
              Tiziana Caem

              Hi Miguel,

              thanks for your suggest.

              I know that NTNAME is the name of user in Windows Active Directory, and in fact my USER1 is the name with which i logon in the system.

              But the Active Directory security ask me my username and psw when i log on by web, and when i declare them my security doesn't work.

              I try to use QVuser(), but it doesn't change...

              any other suggests??

               

                • Security Access
                  Miguel Angel Baeyens de Arce

                  Hello Tiziana,

                  Are you able to read something in your document? Have you tried loading the document with "Initial Data Reduction based on Section Access" and "Strict Exclusion" (Document Properties, Opening) unchecked? Are your users on the form "DOMAINNAME\USERNAME" instead of only "USERNAME"?

                  Regards.

                  EDIT: I told you above about QVUser(), you can check against OSUser() function, which will store the current OS logged user