Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
balkumarchandel
Valued Contributor II

Re: Section Access

are you able to access from desktop ?

Re: Section Access

Hi,

For which user you are getting that error??

Try with Capital Letters

Regards

Regards,
Prashant Sangle
MVP
MVP

Re: Section Access

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

Re: Section Access

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
Contributor II

Re: Section Access

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
Contributor II

Re: Section Access

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
Contributor II

Re: Section Access

Hi Jonathan

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

Re: Section Access

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,*

Employee
Employee

Re: Section Access

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
Contributor II

Re: Section Access

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.