topic Section Access not working when refreshing from Management Console in QlikView

Section Access not working when refreshing from Management Console

Mon, 26 Jan 2026 18:19:17 GMT

I developed a model and implemented Section Access.

The security is at sheet level.

I have included the Service account name with the account seeing all sheets.

When I refresh manually and open the model, the security works fine but when I refresh the model through Management Console the model seems to lose the security and all sheets are available to all users.

Any idea why this is or how I can fix it?

Regards,

Magen

Re: Section Access not working when refreshing from Management Console

avinashelite — Wed, 10 Jun 2015 12:59:16 GMT

can you please share the section access script ??

Have you checked the conditions properly ??

Re: Section Access not working when refreshing from Management Console

marcus_sommer — Wed, 10 Jun 2015 16:20:35 GMT

Section Access worked by design only by opening the application and each refresh or reload from users will leverage the protection. This meant you need to make sure that no refresh or reload from users is possible.

- Marcus

Re: Section Access not working when refreshing from Management Console

stabben23 — Wed, 17 Jun 2015 22:37:20 GMT

Hi, if you exclude your service account where you load your sheet access, then it should work.

LOAD

FROM

[..\Qvds\Users-QlikView_Dev.xlsx]

(ooxml, embedded labels, table is [SHEET ACCESS])
where NTNAME <> "Your service account";

Re: Section Access not working when refreshing from Management Console

Anonymous — Thu, 18 Jun 2015 01:43:16 GMT

Section access is for the row level security. Can be for the column level by using OMIT.

Could you please elaborate how exactly "The security is at sheet level" is implemented in your case? (I don't use section access for this.)

Re: Section Access not working when refreshing from Management Console

Bill_Britt — Fri, 19 Jun 2015 11:24:01 GMT

HI,

Do you have this set? Also, can you post your Section Access Script?