topic Re: Section Access in server disappear in QlikView

Section Access in server disappear

amira_khemissi_ — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I develop a script to secure my application based on 3 fields (F1,F2 and F3) and the NTNAME, I created a key of security like F1|F2|F3 in my data model in the fact table, so for every line I have one security key.

In my script I load the QVD containing abilities, it contains also the ADMIN user on server as service account with * on the 3 fields.

I tested my application in local QV desktop it works fine with my NTNAME also on the laptop of my colleague, but when i deploy on the server it cant identify me by the NTNAME, I used the OSUser() in text object so it show correctly my NTNAME I also displayed the field NTNAME in the data model that contains all NTNAMES from the QVD on my laptopo it reduce on my NTNAME on the server it reduce on the service account so I can see every thinghowever I shouldn't.

Can you help me please?

Thank you

Re: Section Access in server disappear

YoussefBelloum — Tue, 20 Feb 2018 15:32:37 GMT

Hi,

on you laptop, when you reload, you save, you close the app and you re open it to test if the secttion access is ok ?

you should not test just after the reload, you should save, close and re open

Re: Section Access in server disappear

amira_khemissi_ — Tue, 20 Feb 2018 15:36:56 GMT

Youssef thank you for your reply,

Yes I closed the app and reopend it then the security works fine as defined in the QVD, I also tested with my colleague date is reduced as defined for him, the problem appear when I distribute the app on the QMC

Re: Section Access in server disappear

YoussefBelloum — Tue, 20 Feb 2018 15:42:39 GMT

Try to attach your section access script

Re: Section Access in server disappear

shilpan — Tue, 20 Feb 2018 15:54:42 GMT

Make sure that you reload once on your local machine before deploying it to server.

Re: Section Access in server disappear

amira_khemissi_ — Tue, 20 Feb 2018 16:04:24 GMT

Please find the script attached,

In my data model I have table like

witch contains in the _CLE_LP field the Key created for every line in the fact table and in the _CLE_SEC field all combination possible for every value

Re: Section Access in server disappear

amira_khemissi_ — Tue, 20 Feb 2018 16:04:44 GMT

I do