Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have a Section Access script wich works perfectly from an INLINE, this is the script:
LOAD * INLINE [
ACCESS, USERID, Year
ADMIN, domain\user1, 2015
];
(User1 only can see 2015 information)
BUT when i load the data from excel doesnt get access to me.
This is what im doing and what im trying:
Trying this to:
and this...
But the result is always the same: "Access denied". Its wierd because is already working with an inline. What do i miss??
Does your inline load also have the Year field completely in upper case, i.e YEAR instead of Year?
Does your Excel file contains upper case values like ADMIN and USER instead of Admin and User?
I think that you need to add
Where 1=1 to your from statement for this to work with section access
- Year, but is working...also works with YEAR.
- Yes it does
Doesn´t work with that, still "access denied"
This is what I am doing in my app. I am loading from a QVD instead of Excel and it work fine.
Section Access;
// *************************************************************
// Load QVD file created by Security Extract Task. This updates nightly
// *************************************************************
LOAD
"ACCESS",
"USERID",
CUSTOMERID
FROM [lib://QVD Files $(vEnvironment)/Healthmax/USERAUTHORIZATION.QVD](qvd)
Where 1=1;
Hi
As i have mentioned in the previous thread as well you need to specify which field you are refering from your database will come under Section application which will pick data from resident table/load data from database. That is how i worked with excel.
My data is reduced in the desired way.
I have a question.
Can i have 2 section access in one app?? One for groups and other for user? Something like this.
Section access;
Load * inline[
Access, userid
ADMIN, user1
];
Section Application;
Section Access;
Load * inline[
Access, group
];
Section Application;
Dear Segbastian,
Try to create the same app like this help.
PS: on Qlik Sense, the section access works fine after aplication published. I recommend close the browser and open a private mode to reproduce the access.
Regards
Hi Ricardo.
I´ve already saw the guide, but dont explain how to create the groups? are AD groups? so doesnt need domain? And the guide doesnt answer my questions.
regards