Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik sense: Section Access issue using email as USERID

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

3 Replies
arvind654
Honored Contributor II

Re: Qlik sense: Section Access issue using email as USERID

DYNAMIC SECTION ACCESS

Start is *;

Section Access;

USER_TEST:

LOAD

    'USER' as ACCESS,

   upper([email]) as USERID,

   [AnalysisGroup] as REDUCTION;

SQL SELECT

FROM ReportingDatabase.dbo."User"

where RoleId in (30,40);

Load  * inline [

ACCESS, USERID, REDUCTION

ADMIN,ABC\BLOGG1, *

ADMIN, SERVICEACCOUNT\BLOGG1, *

USER,USER\BLOGG1, USA

];

section application;

You can try above script?

And yes, you should load the table before or can store into QVD so that SA can match the fields

USERROLE:

LOAD

     'USER' as ACCESS,

   upper([email]) as USERID,

   [AnalysisGroup] as REDUCTION;

LOAD

    'USER' as ACCESS,

   upper([email]) as USERID,

   [AnalysisGroup] as REDUCTION;

SQL SELECT

FROM ReportingDatabase.dbo."User"

where RoleId in (30,40);

Store USERROLES into ........qvd

Not applicable

Re: Qlik sense: Section Access issue using email as USERID

Hi,

Thanks for getting back to me. Sorry to say your solution does not allow me to see the mashup in our web portal. I am still getting an Access Denied error.

arvind654
Honored Contributor II

Re: Qlik sense: Section Access issue using email as USERID

Hi,

It will work normally but I have never worked on Mashup. So couldn't help much, sorry.