3 Replies Latest reply: Nov 29, 2016 9:51 AM by Aehman K RSS

    Qlik sense: Section Access issue using email as USERID

    Shane Streeting

      Hi,

       

      I am trying to embed a mashup in a web page.

      The customer logs into the web site and selects an option from a drop down menu that takes them to the mashup.

      Unfortunately they are getting an "access Denied" error.

       

      In my section access tab, i have the following code.

       

      USER_TEST:

      LOAD

          ACCESS,

          USERID,

          REDUCTION;

      SQL SELECT 'USER' as ACCESS, upper([email]) as USERID, [AnalysisGroup] as REDUCTION

      FROM ReportingDatabase.dbo."User"

      where RoleId in (30,40);

       

      section access;

      Load  * inline [

      ACCESS, USERID, REDUCTION

      ADMIN,ABC\BLOGG1, *

      ];

      section application;

       

      DROP TABLE USER_TEST;

       

      The USERID data takes the form of "joe.blogs@customer.org.uk"

      The "ABC\BLOGGS1" line gives me the access to edit the qliksense app, without locking me out.

       

      Can i mix my USERID data? Eg AD accounts and email addresses?

      Any suggestions as to what i am doing wrong would be appreciated.

       

      Thanks,

      Shane