Document should be accessed by only 3 people ( Section access)

[chiru_thota]

Hi all,

I want to give QVW access to only for three people and all three should be able to see all the data.

Other than this 3 users should not able to open the QVW.

What is best way of doing it ?

I tried below code and unfortunately I am not able to open the document even though I have added my username as Admin.

Section Access;

LOAD * INLINE [

    ACCESS,NTNAME

    ADMIN,DOMAIN\USER1

    ADMIN,DOMAIN\USER2

    ADMIN,DOMAIN\USER3

];

Section Application;

[mgavidia]

The thing I noticed is that you are missing the Password column in your script.

Section Access;

LOAD * INLINE [

    ACCESS,   NTNAME,                  PASSWORD

    ADMIN,      DOMAIN\USER1,      PWDU1

    ADMIN,      DOMAIN\USER2,      PWDU2

    ADMIN,      DOMAIN\USER3,      PWDU3

];

[chiru_thota]

Thanks MIGUEL GAVIDIA

I don't want to put any password for them...Those 3 users shouls be identified by their NTNAME & UserName

Is that possible ?

[vardhancse]

Hi Chiru,

1.     In QMC task you can go to distribute tab ->named users and can distribute to only required members.

          so that only those members will have access to dashboard with all the data.

2.     Based on the field data if you want to filter data means

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, LOCATION

    ADMIN,DOMAIN\ABC,INDIA

    ADMIN,DOMAIN\ABC,CHINA

    USER,DOMAIN\ABC,US

];

[Or]

It looks like you've got the right syntax, though the domain is only necessary if you are accessing QV from outside the domain. In order to make sure you have the right usernames, open any QlikView model and add an object with the expression:

=OSUser()

Make sure the result matches your script.

[arsal_90]

Please make a excel file

ACCESS	USERID	GROUP
Admin	Admin	GROUP1
Admin	domain\abc	GROUP1
User	domain\abc	GROUP2

Section Access;
LOAD upper(ACCESS) as ACCESS,
upper(USERID) as USERID,
upper(GROUP) as GROUP
FROM
[Jubilee Insurance Dashboard Security.xls]
(biff, embedded labels, table is [Sheet1$]);

Section Application;

[arsal_90]

Section Access;

LOAD * INLINE [

ACCESS, USERID,  REGION

ADMIN, ADMIN, ADMIN,

USER, USER1,  AFRICA

USER, USER2,  AMERICA

USER, USER3, ASIA

USER, USER4, EUROPE

USER, USER5, AMERICA

];

Section Application;

Please remember your section access in Hidden Script then it's work else they didn't work

[arsal_90]

Please make a excel file

ACCESS	NTNAME	GROUP
Admin	Admin	GROUP1
Admin	domain\abc	GROUP1
User	domain\abc	GROUP2

Section Access;
LOAD upper(ACCESS) as ACCESS,
upper(USERID) as USERID,
upper(GROUP) as GROUP
FROM
[Jubilee Insurance Dashboard Security.xls]
(biff, embedded labels, table is [Sheet1$]);

Section Application;

Please remember your section access in Hidden Script then it's work else they didn't work

[chiru_thota]

Thanks All,

I figured out finally that no problem with my syntax and it worked perfect.

By mistake I have used different domain name for a user instead of his actual domain.