topic Re: No Access for USER - Section Access in App Development

No Access for USER - Section Access

sroettger — Sat, 16 Nov 2024 05:06:24 GMT

Hi!

I have a problem with QlikSense Server respectively an App.

The App has an Section Access and is published on a stream. The section access work correctly, but user with ACCESS Level USER can’t login into the App. access denied. Only when I change the rights to ADMIN, do they come on the App. For these users there are no further restrictions

I checked the user id, the Licensing, restart the Server, close any Browser, and so on. Nothing works.

Thank you for any ideas!

Re: No Access for USER - Section Access

miskinmaz — Wed, 31 Jul 2019 06:44:55 GMT

You can't keep blank cell or no data for authorization with Access type User.

Can you explain in detail on what field the authorization is handled.

If it is a complex authorization on multiple field you can follow Henric blog:

https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872

Re: No Access for USER - Section Access

sroettger — Wed, 31 Jul 2019 07:16:58 GMT

Here is the Code:

Section Access;
SELECT
[ACCESS]
,[USERID]
,upper([VERTRIEB]) as [FACTURA.VERTRIEB]
,upper([NIEDERLASSUNG]) as [FACTURA.NIEDERLASSUNG]

FROM [Qlik].[dbo].[vPermission]
WHERE [Qlik].[dbo].[vPermission].IDApp=2;

Section Application;

Here is a screenshot of the table:

Re: No Access for USER - Section Access

miskinmaz — Wed, 31 Jul 2019 08:36:33 GMT

Since the authorization is on multiple field it is better to follow the blog mentioned to u earlier.

Or else you can continue by assigning the ADMIN access type to users as well.