Section Access

[rido1421]

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;

[Anonymous]

are you able to access from desktop ?

[PrashantSangle]

Hi,

For which user you are getting that error??

Try with Capital Letters

Regards

[jonathandienst]

Use the script given to you above by max dreamer -  dreamer4

[avinashelite]

Hi Rido,

It depends on the data what you have, and how your defining in the section application.

can you please share the sample app

[rido1421]

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

USER, domainname\kevinw , 2101,*

I am getting it for peterz. after doing the above...

I have tried Capital and lowercase.

[rido1421]

I am trying from the desktop through the access point.

Im afraid to close the document on the server after saving as it might block me out of the document on the server.

peterz is my user on the server aswell.

[rido1421]

Hi Jonathan

I have used the Script. it has taken access for peterz away completely...

[avinashelite]

try some things like this

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

USER, domainname\kevinw , 2101,*

[ToniKautto · Accepted solution]

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;

[rido1421]

Hi Avinash.

Im not sure how I would give a sample of the model it is a bit complex.

The field names that I am trying  to restrict, COST_CENTRE and CODE_2 , Does it have to come from the fact table or is there any specific requirement with regards to these fields.

I have just taken the fields as is and tried to limit access.