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: 
rido1421
Creator III
Creator III

Section Access

Hi There

Something is not working correctly in my section access.

My qlikview user is peterz.

when reloading with the below section access applied.

my user peterz can only see CODE_2   A12.

According to my script, peterz must have access to all CODE_2

it seems as if all other users can also only see A12

for now it seems like kevin can see only A12 CODE_2s linked to COST_CENTRE 2101.

he needs to see all CODE_2s for COST_CENTRE 2101

Your assistance is appreciated.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\Johna , *, A12
USER, domainname\peterz ,*, *
USER, domainname\paulo ,*,*

USER, domainname\kevinw , 2101,*

 


  ];

Section Application;

1 Solution

Accepted Solutions
ToniKautto
Employee
Employee

A few things to look at with your example;

- All fields in the section access table must be in UPPER case

- You might want to have at least one ADMIN level user

- * represents all values listed in the reduction field, use a non existing value to represent all data values

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\JOHNA , <ALL VALUES>, A12
USER, DOMAINNAME\PETERZ ,<ALL VALUES>, <ALL VALUES>
USER, DOMAINNAME\PAULO ,<ALL VALUES>,<ALL VALUES>

USER, DOMAINNAME\KEVINW , 2101,<ALL VALUES>

];

Section Application;

Try using USERID instead of NTNAME during your development work. That way you can impersonate your users in an easy way, by entering the USERID in the login credentials.

Section Access;

LOAD * INLINE [
ACCESS, USERID, COST_CENTRE, CODE_2
USER,DOMAINNAME\JOHNA , <ALL VALUES>, A12
USER, DOMAINNAME\PETERZ ,<ALL VALUES>, <ALL VALUES>
USER, DOMAINNAME\PAULO ,<ALL VALUES>,<ALL VALUES>

USER, DOMAINNAME\KEVINW , 2101,<ALL VALUES>

];

Section Application;

View solution in original post

29 Replies
rido1421
Creator III
Creator III
Author

FYI.

I have tried using CAPS

I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.

PrashantSangle

Hi,

Kept it blank to give all acesss

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\Johna , *, A12
USER, domainname\peterz ,,
USER, domainname\paulo ,*,*

USER, domainname\kevinw , 2101,*

 


  ];

Section Application;

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

* represent the value for that which mention in section Access

and to give all access you have kept that field blank.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
rido1421
Creator III
Creator III
Author

Thanks Max Dreamer

I will try it and let you know. just to confirm, when you do a Debug load with section access does it work correctly?

PrashantSangle

Hi,

Depend on data...

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable

hi,

keep blank at the place of *. they will see all values.

LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2

USER, domainname\kevinw , 2101,

  ];

Regards

Vimlesh

rido1421
Creator III
Creator III
Author

"Failed to Open Document, You do not have access to this document"

This is the Error received... when tryng to access through the access point

rido1421
Creator III
Creator III
Author

Hi Vimesh

If I remove my User: peterz will it not take away my access to the document completely?

Anonymous
Not applicable

Generally Debug load with section access does not work .

You need to reload the document save it and close it .

Again open the doc .you should be able to login with correct user ID pwd.