Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
prat1507
Specialist
Specialist

Section Access with 2 USERID entries

HI All

I'm struggling with section access where I have implemented the code as below:

section access;

Star is *;

LOAD * inline [
ACCESS, USERID, MA, MO1, MO2, MO3
ADMIN, DOMAIN\pshastr2, , PRATYUSH, ,
ADMIN, DOMAIN\pshastr2,  PRATYUSH, , ,
ADMIN, DOMAIN\nbafna2, NILESH, , ,
ADMIN, DOMAIN\psahoo11, , PRAVAT ,
];

section application;

UserDetails:
Load * Inline [
MA, MO1, MO2, MO3
NILESH, PRATYUSH, SANDEEP, GAURAV
NILESH, SANDEEP, PRATYUSH,  GAURAV
NILESH, PRAVAT, PL, BB
NILESH, UMESH, TX, TY
];

 

When I'm logging in as DOMAIN\pshastr2, I should only see the first two records of my inline table, but I'm seeing all the records. What is wrong here? Please guide

 

Regards

Pratyush

4 Replies
Vegar
MVP
MVP

prat1507
Specialist
Specialist
Author

I even tried this, on Putting access as USER, it says Access Denied. I can't understand why this is happening.

Regards
Pratyush
Vegar
MVP
MVP

My guess is that you have not have a match for all SA reduction fields. I notice that you kept many of the reductions empty, you should define them explicit. (You could use start *, but make sure you use it correctly.)
prat1507
Specialist
Specialist
Author

Hi Vegar

I even tried with that, but it is still showing all the data. It is behaving very absurdly, and I'm not able to understand why did it say access denied when I gave the access as USER instead of ADMIN.

Very confused, don't know how to move forward on this.

Regards

Pratyush