topic Re: Section Access Limitation? in App Development

Section Access Limitation?

ali_hijazi — Wed, 10 Mar 2021 10:13:32 GMT

Hello

we've got a QVF to which we added section access
some users got ADMIN access and others got USER access with data reduction
we have no problems with ADMIN users and they see all data
some users and mainly those with USER access are not seeing all data they are supposed to see
let's say we have user U1, this user has over 1 million rows (distinct combinations) that link to schema
if we put all these combinations in the section access table, this user will not see all the possible linked data
but if we disable the "section access" and select the userid from UI there is no problem;

so I was wondering if there is a limitation in section access for the number of rows per user
kindly advise

Re: Section Access Limitation?

eliran — Wed, 10 Mar 2021 10:54:42 GMT

There is no limitation for data reduction to my knowledge and experience.

Usually this happends when you don't really cover all of the situations.

What I usually do when there is a problem in the section access, is remove the 'section access / section application' part of the script, and just load the security table to the ERD schema.

Once there, I can understand fully what is happening with the data interaction.

I hope it helps,

Eliran.

Re: Section Access Limitation?

ali_hijazi — Wed, 10 Mar 2021 11:12:08 GMT

this is what I'm doing
when I remove the section access / section application I can check for that particular user what related data he can see and it is working fine
but once I enable section access that user won't see all related data
weird

Re: Section Access Limitation?

ali_hijazi — Fri, 12 Mar 2021 15:04:00 GMT

it turned out there is a limitation of rows per user in the section access table
as per this article:
https://support.qlik.com/articles/000048245

the limitation is set to 1,000,000 rows
and it turned out that we exceeded this limit in the section access table (per user)