Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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