section access issue?

[Akina0929]

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

[prieper]

You need to set the tickmarks in Document settings on open

Peter

[Akina0929]

Hi Peter Rieper,

     I have selected the that both options.

[trdandamudi]

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
];

[Akina0929]

Hi  Thirumala,

    getting same.

[Peter_Cammaert]

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.

[Akina0929]

HI.

I am qv desktop.

[Akina0929]

sorry..

I am using Qv Desktop

[trdandamudi]

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

[beck_bakytbek]

Hi Anji

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

i hope that helps

Beck