topic new to section access in QlikView

new to section access

Wed, 23 May 2012 19:18:40 GMT

I am trying to limit data based on the userid by loading inline -

Section access;
LOAD * Inline
[
ACCESS, USERID, Segment1_GL
ADMIN, ADMIN, 70200
USER, USER, 70400
];

Section application;

This does not seem to work. Regardless of how i login, i can access both the GL segment data.

new to section access

Wed, 23 May 2012 19:33:29 GMT

As I read the Security section, it restricts users from making changes to the sheet (adding/deleting objects, etc.), but not from just seeing the sheet and its data. Are you trying to restrict users from seeing an entire section of the document, or just from making changes to it?

Re: new to section access

Wed, 23 May 2012 20:35:15 GMT

Ok. so i found the issue. I was not including the password.

But, now i have another problem. Can the data reduction value include a comma?

Section access;
LOAD * Inline
[
ACCESS, USERID, PASSWORD, BUSINESSLEAD
ADMIN, ADMIN, ADMIN, *
USER, USER, USER, 'Smith, Joe'
];

Section application;

When i login as USER, qv denies access.

Re: new to section access

Wed, 23 May 2012 21:06:02 GMT

How are your users logging into QV? Are they prompted for their user name and password on login or are you using Windows authentication?

Re: new to section access

Fri, 27 Jul 2012 16:18:36 GMT

No. Try the followign by repeating the rows. This is not as scalable as perhaps somethign like [x,y,z]

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REGION
Admin, Matt, XX
User,molenich,SE

User,molenich,NE
];
Section Application;