Section Access

[dcd123456]

Hello

I have a QV document with a Section Access defined to limit the data that a user can see, but the filter don't work.

The section access is:

Section Access;

SECURITY:

LOAD * INLINE [

   USERID, Grupo

   P16280, t1

];

but the user P16280 can see everything.

The user P16280 is my user and i have used the windows client.

I have attached an example.

thanks

regards

diego

[vikasmahajan]

Go to Document setting->Opening -> Tick  ->Initial Data Reduction

and  Initial Selection base on Section access .

Please PFA attached full section access documents for reference.

Vikas

[manojkulkarni]

I have modified your application. pls check..

[maxgro]

I changed your doc (as Vikas suggests and other changes too, see attachment)

user and pwd  are

ADMIN ADMIN

P16280 P16280

make a backup of your docs before trying section access

read the pdf (attachment), an old but very good doc about section access

[dcd123456]

Hello

Thanks for your answers it works ok.

I have changed the field USERID to NTNAME and now QV take the user id from windows.

is there a way to restrict acess to the data using windows groups instead windows  user id?

thanks

regards

diego

[#6 · Accepted solution]

The referance manuel says about NTNAME:

"A field that should contain a string corresponding to a Windows NT Domain user name or group name."

You may use also NTDOMAINSID

Fabrice