4 Replies Latest reply: Dec 17, 2009 10:00 AM by ivanov RSS

    How to set up a user with all data access? (Data Reduction Based on Section Access is enabled)

    ivanov

      Hi all,

       

      I'll use an example to make the problem clear:

       


      Section Access;

      Star is *;

      UserAccess:
      LOAD * INLINE [
      ACCESS, USERID, PASSWORD, DEPARTMENT
      ADMIN, a1, a1,
      USER, u1, u1, D1
      USER, u2, u2, D2
      USER, u3, u3, *
      USER, u4, u4
      ];

      Section Application;

      Departments:
      LOAD * INLINE [
      DEPARTMENT
      D1
      D2
      D3
      D4
      D5
      ];


       

      The result is the following:

      a1 has access to all departments,

      u1 has access to department D1,

      u2 has access to department D2,

      u3 has access only to departments D1 and D2,

      u4 doesn't have any access ("Access denied to this QlikView document").

       

      So I can't set up a USER (not ADMIN) with access to all departments. As you can see I tryed both * and null in DEPARTMENT field. But it doesn't work. Is it bug or feature? Maybe it works different on server? I'm using QlikView 9 SR2.