topic Section Access and Custom users in QlikView

Section Access and Custom users

fredericvillemi — Wed, 22 Feb 2012 09:52:56 GMT

Hi,

i am using Custom Users and i want to make a secure document.

if i have a Custom User called Custom\TEST1, will this section access work :

LOAD * INLINE [

ACCESS, USERID

ADMIN,TEST1

];

or should i use NTNAME or CUSTOM\TEST1 ?

Can i omit the password field as the password is defined in Qlikview itself ?

Thanks

Section Access and Custom users

jagan — Wed, 22 Feb 2012 10:02:25 GMT

Hi,

Find the script below which implements the Section Access based on the Users department.

If the user has access to department 1 then he can see only his department data. We need to give the password if the user is custom.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, Sales, password1, 1

USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Dept,

1, Sales

2, Marketing];

Sales:

LOAD * INLINE [

Dept, Sales

Sales, 100

Sales, 200

Sales, 4646

Sales, 755

Sales, 422

Sales, 42

Marketing, 2

Marketing, 453

Marketing, 54

Marketing, 45

];

Hope the script helps you in understanding.

Regards,

Jagan.

Section Access and Custom users

fredericvillemi — Wed, 22 Feb 2012 10:05:41 GMT

I understand your example but my problem is that i'm using the Custom Directory from Qlikview

Thus i don't want users to log again to open their document .. and i don't know their password to put in each model

They are connected to Accesspoint with their custom login (example : test1) and i want them to be able to see and open secured documents.

Section Access and Custom users

Anonymous — Wed, 22 Feb 2012 11:22:29 GMT

Frédéric,

If you don't want users to login again, use NTNAME instead of USERID. Password is not necessary, you need only ACCESS and NTNAME.

Regards,
Michael