Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Yes. Everything!
now, when using * in your section access are you:
i suggest you run section access script without section access statement to see if tables link properly!
see how it goes
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
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
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