Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Hi,
It will work normally but I have never worked on Mashup. So couldn't help much, sorry.