Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Sheet level security - One user - Two security groups

Sheet level security question:

I have a situation where we have a user applied to a limited access security group within QV that restricts access to a specific sheet and then we also have the same user that is also applied to another security group that does allow detail access to that same specific sheet.  Below is the logic in the edit script and the show sheet properties.

Edit Script Logic:

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, OMIT
User, CompanyABC\ABCNoDetailAccess, NoDetail
User, CompanyABC\ABCDetailAccess

]
;
Section Application;


DetailAccess:
LOAD * INLINE [
NoDetail
1
]
;

Show sheet Conditional properties logic:

=If(sum(NoDetail)>0,1,0)

From testing we have performed there are times the users can see the details and times they cannot.  I made an assumption that qlikview would process the SectionAccess INLINE table and take the last group and apply the detail level access to this specific users.  How does Qlikview handle this situation?


Thanks

Community Browser