Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aitmessaoudali
Creator
Creator

Section access-access denied

hello everybody,

i'm trying to create a section access on the script. I've tried so many scripts but i always get the error 'access denied'.

Here is the last script i used :

SECTION ACCESS;

LOAD * inline [

ACCESS, USERID,PROFIL_1

ADMIN, DOMAIN\AMESSAOUD,*

USER, DOMAIN \READER1,-1

USER, INTERNAL\SA_SCHEDULER,*

];

SECTION APPLICATION;

Star is *;

in the profil table, i renamed profil_1: upper(profil_1) as PROFIL_1

can someone please help me find where the error is?

11 Replies
Lisa_P
Employee
Employee

PROFIL_1 is not a valid field in Section access.  What are you trying to do ?

Possible fields are GROUP or OMIT.

rittermd
Master
Master

If PROFIL_1 is the name of the field you are checking for the value then it must match the name in your table exactly.

Is your DOMAIN name really DOMAIN?

agigliotti
Partner - Champion
Partner - Champion

how are you using PROFIL_1 field in your data model ?

is there a field linked to it in your section application ?

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

What are the values in PROFIL_1?

Do you actually have -1?

nsetty
Partner - Creator II
Partner - Creator II

Isn't it NTNAME instead of USERID?  In the Section Access, if you are using domain accounts to login?

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME,  OMIT

];

Section Application;

aitmessaoudali
Creator
Creator
Author

PROFIL_1 is field filled with only 0 or 1

aitmessaoudali
Creator
Creator
Author

they're matching

aitmessaoudali
Creator
Creator
Author

no, i only have 0 or 1

aitmessaoudali
Creator
Creator
Author

tried NTNAME, didn't work neither