topic Re: section access issue? in QlikView

section access issue?

Akina0929 — Wed, 25 Nov 2020 16:16:04 GMT

HI,

I am trying to implement data level security, I wrote the following script for data level security.

But the problem is every user is able to see all the data, data restriction is not working.

i have check the option in Document properties-->opening--->initial data reduction based on section access also

Thanks and regards

Anji

Re: section access issue?

prieper — Fri, 12 May 2017 11:26:09 GMT

You need to set the tickmarks in Document settings on open

Peter

Re: section access issue?

Akina0929 — Fri, 12 May 2017 11:31:46 GMT

Hi Peter Rieper,

I have selected the that both options.

Re: section access issue?

trdandamudi — Fri, 12 May 2017 11:42:01 GMT

The issue is in the script. You are using the key word "Section Access" in the section application. Try the below code and it will work:

SECTION Access;
Load * Inline [
ACCESS, USERID
ADMIN,ANJI
USER, NARESH
];

Section Application;
Data:
Load * Inline [
USERID, %COUNTRY,AMOUNT
ANJI,INDIA,1000
NARESH,CHINE,2000
];

Re: section access issue?

Akina0929 — Fri, 12 May 2017 11:48:22 GMT

Hi Thirumala,

getting same.

Re: section access issue?

Peter_Cammaert — Fri, 12 May 2017 11:54:47 GMT

There are only two users. Did you test your document with user NARESH? Which client did you use to test your secured document? QV Desktop? Ajax client?

An ADMIN user has always access to all data in QV Desktop.

Re: section access issue?

Akina0929 — Fri, 12 May 2017 11:58:22 GMT

HI.

I am qv desktop.

Re: section access issue?

Akina0929 — Fri, 12 May 2017 11:59:55 GMT

sorry..

I am using Qv Desktop

Re: section access issue?

trdandamudi — Fri, 12 May 2017 12:36:16 GMT

Can you please check the attached file. It is working on my side on QV desktop.

Re: section access issue?

beck_bakytbek — Fri, 12 May 2017 13:27:49 GMT

Hi Anji

look at this: https://www.youtube.com/watch?v=_5SNY_UZBtQ

i hope that helps

Beck

Re: section access issue?

prieper — Fri, 12 May 2017 13:39:06 GMT

.... and a Field %COUNTRY exists in the application?