Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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
aitmessaoudali
Creator
Creator
Author

why is it not a valid field? i have it on a previous table so it must work

MK9885
Master II
Master II

Maybe

Star is *;

SECTION ACCESS;

LOAD * inline [

ACCESS, USERID,PROFIL_1

USER, DOMAIN\amessaoud,*

USER, DOMAIN \reader1,-1

USER, INTERNAL\sa_scheduler,*

];

SECTION APPLICATION;

I have not seen an NTName with case sensitive (all in caps)... maybe thats the reason?

Give Access as USER to everyone

Make sure you have -1 in your PROFIL_1 field

As per above script amessaoud will have access to -1 and reader would also have access to -1... so it doesn;t make much difference with Star is *;

Unless you add one more value which is 0 then amessaoud will have access to full data as 0 and 1.