Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

NTNAME Section Access

Hi i trying to make a put a section access in my qlw script, but i have a problem, i wanto to make visible only some object to ntname (the windows users) when log into my qlikview project with internet explorer or firefox.

My code in my script is that:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, PASSWORD

    Admin, domani\useradmin, pwdadmin

    User, domain\user_one, pwduser_one

    User, domain\user_two, pwduser_two

];

Section Application;

ChartAccessMatrix:

LOAD * INLINE [

NTNAME, CH31, CH27

domani\useradmin,1,1

domain\user_one,1,1

domain\user_two,0,0];

The problem is when with my broswser i connect to the AccessPoint and make the login with USER_TWO, i see all two object i set to 0, why?

6 Replies
Highlighted
Master II
Master II

Hi,

try to follow this steps (USERID must be in Uppercase)

Chart Level Access by user

edited:

The problem is when with my broswser i connect to the AccessPoint and make the login with USER_TWO, i see all two object i set to 0, why?

which mean the user (USER_TWO) can see the chart object ( Object ID: CH27 )


Thanks,Deva

Highlighted

Because there is no connection using the NTNAME field itself, that's why you have to create a reduction field named differently, in the section access table, and use this field to reduce data for users.

Following your example, add a AUTHORIZEDUSER field (as this is not a reserved field name) in the first table with the same contents as the NTNAME field, and then use this USERNAME field in the second table (ChartAccessMatrix).

Highlighted
Creator III
Creator III

sorry i think not properly understand, so my code now is:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, PASSWORD, AUTHORIZEDUSER

    Admin, domani\useradmin, pwdadmin, domani\useradmin

    User, domain\user_one, pwduser_one, domain\user_one

    User, domain\user_two, pwduser_two, domain\user_two

];

Section Application;

ChartAccessMatrix:

LOAD * INLINE [

USERNAME, CH31, CH27

domani\useradmin,1,1

domain\user_one,1,1

domain\user_two,0,0];

but the same when i connect in my access point with "domain\user_two" i see the charts....

Highlighted
Creator III
Creator III

so i tried into this mode too... but same result when i connect to access poit with that user (using windows autentication), when i choice the project i want to see, it ask me the name of the user, so i put: USER_TWO, but the USER_TWO show again the 2 charts...... i need not show for this user... i think the code in script is ok:

Section Access;

LOAD * INLINE [

    ACCESS, USERID

    Admin, USERADMIN

    User, USER_ONE

    User, USER_TWO

];

Section Application;

ChartAccessMatrix:

LOAD * INLINE [

USERID, CH31, CH27

USERADMIN,1,1

USER_ONE,1,1

USER_TWO,0,0];

Highlighted
Master II
Master II

Hi,

Please refer to the attached sample. have u done with conditional display chart option? if not u have to set like below

1) go to settings--> document properties ---> opening --> enable below check box

3.JPG

2) conditionally display on chart 31

1.JPG

3) conditionally display on chart 27

2.JPG

4) then u can try to close and re-open u r qlikview document then it will prompt user ID  (try to check below ID & it should work as mentioned below -tested fully.)

LOAD * INLINE [

USERID, CH31, CH27

USERADMIN,1,1

USER_ONE,1,1

USER_TWO,0,0

USER_THREE,0,1];

Hope it helps

Thanks

Deva

Highlighted

Use UPPERcase for both field names and values in both section access and data tables. That should work.


See example attached (don't save the file!):

User with permissions: USER1 password USER1

User without permissions (no chart): USER2 password USER2