NTNAME Section Access

[danosoft]

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?

[devarasu07]

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

[Miguel_Angel_Baeyens]

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).

[danosoft]

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....

[danosoft]

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];

[devarasu07]

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

2) conditionally display on chart 31

3) conditionally display on chart 27

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

[Miguel_Angel_Baeyens]

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