6 Replies Latest reply: Oct 3, 2017 8:03 AM by pradosh thakur RSS

    section access in qs

    Manoranjan D

      hi all below is my coding of qliksense which is not working fine for me, i have given access to me(X123456) as admin for all account as *, after runing and seeing the app it is not showing the app and getting as an access denied.

       

      pls help me on this

       

      SECURITY_USER_TABLE:

      LOAD

          FIRSTNAME,

          "ACCESS" as ACCESS,

         'XO2\'& "USERID" as USERID,

          XLCOMPANYGUID

      FROM [lib://vPrepQVDPath (XX011_X123456)/TRANSFORMATION_SECURITY.qvd]

      (qvd);

       

       

      Concatenate

      LOAD * INLINE [

      FIRSTNAME,ACCESS,USERID,XLCOMPANYGUID

      QASERVICEACCOUNT1,ADMIN,X02\SADD02QlikSenseQA,

      QASERVICEACCOUNT2,ADMIN,INTERNAL\X02QlikSenseQA,

      Manoranjan,ADMIN,RO2\X123456,*

      Vignesh,ADMIN,RO2\X122756,*

      Karan,ADMIN,RO2\X123410,*

      ];

       

       

       

       

      SECTION ACCESS;

       

       

      LOAD

      UPPER(USERID) AS USERID,

      UPPER(ACCESS) AS ACCESS,

      UPPER(XLCOMPANYGUID) as XLCOMPANYGUID

      Resident SECURITY_USER_TABLE;

       

       

      SECTION APPLICATION;

       

       

      Drop Table SECURITY_USER_TABLE;