topic Section Access in QlikView

Section Access

dcd123456 — Mon, 17 Feb 2014 08:44:23 GMT

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

Re: Section Access

vikasmahajan — Mon, 17 Feb 2014 08:52:14 GMT

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

Re: Section Access

manojkulkarni — Mon, 17 Feb 2014 09:01:50 GMT

I have modified your application. pls check..

Re: Section Access

maxgro — Mon, 17 Feb 2014 09:01:57 GMT

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

Re: Section Access

dcd123456 — Mon, 17 Feb 2014 09:49:05 GMT

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

Re: Section Access

Mon, 17 Feb 2014 10:05:32 GMT

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