Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

new to section access

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.

4 Replies
Not applicable
Author

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?

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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;