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: 
fredericvillemi
Specialist
Specialist

Section Access and Custom users

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

3 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

fredericvillemi
Specialist
Specialist
Author

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.     

Anonymous
Not applicable

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