No Access for USER - Section Access

[sroettger]

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!

[miskinmaz]

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

[sroettger]

Hi

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:

[miskinmaz]

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.