Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
toui
Partner - Contributor
Partner - Contributor

SECTION ACCESS

Hello,

I have an access problem for type ACCESS='USER'.
users have an 'access denied' error message.
On the other hand, when I change everyone to type ACESS='ADMIN' it works even with restrictions on the UG column (as in the example).
could you help me?
THANKS

toui_1-1679928267693.png

 

toui_0-1679928245451.png

 

Labels (1)
1 Reply
BrunPierre
Partner - Master
Partner - Master

Hi, all data loaded from an external data source must be uppercase within the section access statement.

Concatenate(Authorization)
LOAD Upper(ACCESS) as ACCESS,
            Upper(USERID) as (USERID),
  ---- <Others lines here>---