5 Replies Latest reply: Oct 18, 2010 3:36 PM by Michael Solomovich RSS

    Section Access from QVD

    Yuri Nicolett

      Hello,
      I'm trying to make an access control through AD. I'm getting the data I need via LDAP.
      All this is working, but when trying to add a user through an INLINE, this and only this user can not connect to the application.
      Can you help me?


      I use two applications, one to generate the QVD and another that reads this file QVD.

      Here is the code I generate the QVD:

      Access:
      LOAD
      'Admin' as ACCESS,
      'Swbi ' & trim (sAMAccountName) the NTNAME,
      telephoneNumber the restriction;
      SELECT
      sAMAccountName,
      telephoneNumber
      FROM 'LDAP: / / swbi'
      WHERE objectClass = 'user'
      and memberOf = 'cn = App01.ADMIN, OU = Groups, OU = SWB, SWB DC =, DC = inf, dc = br ";

      LOAD
      'USER' the ACCESS
      'Swbi ' & trim (sAMAccountName) the NTNAME,
      telephoneNumber the restriction;
      SELECT
      sAMAccountName,
      telephoneNumber
      FROM 'LDAP: / / swbi'
      WHERE objectClass = 'user'
      and memberOf = 'cn = App01.USER, OU = Groups, OU = SWB, SWB DC =, DC = inf, dc = br ";

      CONCATENATE

      Access:
      LOAD * INLINE [
      ACCESS, NTNAME
      ADMIN srvswbbi \ QlikView
      ];

      Now follows the application code that loads the QVD:

      Access Section;
      LOAD UPPER (ACCESS) the ACCESS
      NTNAME,
      Restriction
      FROM QVD \ SECTIONACCESS \ Acesso.qvd (QVD);

      Application Section;

      Data:
      LOAD * INLINE [
      ID, Restriction, QTD_NUM
      01, 99999999, 10
      02, 23455, 2
      03, 22222, 3
      04, 886767, 11
      05, 99999999, 90
      06, 99999999, 88
      07, 99999999, 6
      08, 9983613, 200
      09, 3837661, 30
      10, 8872836, 95
      ];

      My problem is that the user SRVSWBBI \ QlikView can not access the application.