Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Federicofkt
Contributor III
Contributor III

Access denied with Section Access

Hi, I'm new to Section Access and I have some problem. That's my code:

 

Section Access;
LOAD * inline [
ACCESS, USER.EMAIL
ADMIN, mail@mail.com
USER, mail2@mail.com
]
;
Section Application;

 

where the ADMIN user it's me and the email is 100% correct. The problem is that when I reload the app, it says that I have access denied after the reload. I don't understand what I'm doing wrong here.

 

Update: 

I've added the REDUCTION column (as written in the documentation) with the variable on which I wanted to filter the accesses, like so:

 

Section Access;
LOAD * inline [
ACCESS, USER.EMAIL, KEY_AREAMANAGER
ADMIN, mymail@mail.com, *
USER, mail2@mail.com, X
]
;

with the purpose of letting me see everything and USER see only data related to variable X.

Since then, the disaster: the script gave an "unknown error" after the reload and now neither I and the other user can access the app.

 

How do we solve this? We are both admin and owner of the space and the app, how is it possible that we cannot access? Did we just lost everything?

Labels (1)
14 Replies
Federicofkt
Contributor III
Contributor III
Author

I've put everything in upper case but I'm back to the previous situation where I try to load the data, no error but a message of be careful that I'll have the accesses denied.

 

my script is like so:
Section Access;
LOAD * inline [
ACCESS, USER.EMAIL, KEY_AREAMANAGER
ADMIN, MYMAIL@MAIL.COM, *
USER, USERMAIL@MAIL.COM, X
]
;

 

The emails are correct

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes. Everything!

now, when using * in your section access are you:

  • using declaration: Star is *:
  • having all required values in your section access reduction field (note that * will only populate those which are present in section access so if you have only X your * will only link with X
  • try using explicit link or create linking table within section access to make sure that part works as your issue may be related to * (wildcard) not working

i suggest you run section access script without section access statement to see if tables link properly! 
see how it goes

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Federicofkt
Contributor III
Contributor III
Author

Still same warning.

 

I tried without the section access statement and the table is correctly linked.

In the KEY_AREAMANAGER (reduction) column I have 3 values, X, Y and ND, I'd like to try to let myself see everything and the other user see only X related values.

I still don't understand what's wrong now

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

When you use =OsUser() function in UI does it return your email?

i am just wondering if maybe you are using Qlik IDP and instead you need to use USERID 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Federicofkt
Contributor III
Contributor III
Author

That's the output of =OsUser():

UserDirectory=AZURE; UserId=mymail@mail.com

 

I've tried with replacing USER.EMAIL with USERID, keeping the email adresses, still same warning