topic Re: Section Access issue in QlikView

Section Access issue

dapostolopoylos — Sat, 16 Nov 2024 00:20:57 GMT

Hello, everyone.

I came across a strange situation and i don't know what is going wrong.

I have created a document with Section Access enabled and data reduction based on it.

I am testing if it works well but the changes i am doing to a certain user to check his rights don't seem to work...

He was an admin, i made him a user, then i restricted his data according to a specific business unit and everything worked but when i tried to make him an admin again with unlimited data access it doesn't work...

I have tried restarting the Qlik services but no luck...

Any ideas?

Re: Section Access issue

tresB — Fri, 10 Jul 2020 09:53:54 GMT

How does your section access look like? Could you expand a bit more on 'it doesn't work'?

Re: Section Access issue

dapostolopoylos — Fri, 10 Jul 2020 10:09:35 GMT

It looks like this

Section Access; LOAD * INLINE [ ACCESS, NTNAME, FUNCTIONCODE ADMIN, DOMAIN\ADMIN1, * ADMIN, DOMAIN\ADMIN2, * USER, DOMAIN\USER1, * USER, DOMAIN\USER2, * USER, DOMAIN\USER3, * USER, DOMAIN\USER4, PH03 ]; Section Application; Star is *;

When i tried to change one of the users in order to test data reduction functionality, the changes weren't reversed in the Access Point when i changed it back to the original settings.

Re: Section Access issue

tresB — Fri, 10 Jul 2020 10:17:37 GMT

In access point, the ADMIN is also treated as USER. The admin role is meaningful when you are working in desktop client.

Re: Section Access issue

dapostolopoylos — Fri, 10 Jul 2020 10:22:20 GMT

Ok, understood, we use ADMIN only for developers. You think that this is causing the problem?

Re: Section Access issue

tresB — Fri, 10 Jul 2020 10:26:47 GMT

The developers would probably develop in qlikview desktop (unlike qlik sense) and there they would not see this issue. However, in access point ADMINs are also USERS so they would see the data which is explicitly allowed in section access and NOT like default all data for admins.

Re: Section Access issue

dapostolopoylos — Fri, 10 Jul 2020 10:50:25 GMT

The solution is hidden in this link: https://community.qlik.com/t5/QlikView-Documents/QlikView-Section-Access-Examples/ta-p/1492719

specificaly in the Section Access Example Number 4, i should have searched the forum a little more before posting.

Thank you for your time!