0 Replies Latest reply: Apr 16, 2018 2:47 AM by Manoj Kumar M R RSS

    Qlikview section access; object id based security

    Manoj Kumar M R

      Hi Guys,

       

      I'm trying to configure Object (or chart) based security in QLIKVIEW using section access. Windows user ids are available in a Database table. Section access to provide access to QVW document for specified users works fine, But object access (For object TX01) is not working. User John should not see the object TX01. I referred Chart Level Access by user, but still not working.

      Any help is much appreciated..

       

      USERS:

      LOAD

      'ADMIN' as ACCESS,

      'DOMAINNAME\'&UPPER(WINDOWSUSERID) as NTNAME;

      SQL SELECT *

      FROM UserAccess;

       

      Section Access;

      LOAD *

      Resident USERS;

      Section Application;

       

      OBJ_ACCESS:

      LOAD

      NTNAME,

      if(NTNAME='DOMAINNAME\JOHN',0,1) as TX01

      Resident USERS;