Security Issue in QlikView.

[vijayit43]

Dear All,

            In our Dashboard we applied section Access Security for State and Area Based. For Example : we assign "User A" to a State then it Work Fine, when we assign "User A" to one Area then it Work Fine but when we assign User A to one State and One Area then Show All data for this User. For reference we share our script

Section Access;

SATABLE:

REPLACE LOAD * INLINE [

    ACCESS, NTNAME, UERID, SAUSER, STATE, S4,

    ADMIN, RSPLGROUP\QVADMIN,

    USER, RSPLGROUP\AUD091,, AUD091,  , IN-03-RJ-02, 

    USER, RSPLGROUP\AUD091,, AUD091, JK,    

];

[swuehl]

Have you tried to use a single line for both entity authorizations:

Section Access;

SATABLE:

REPLACE LOAD * INLINE [

    ACCESS, NTNAME, UERID, SAUSER, STATE, S4,

    ADMIN, RSPLGROUP\QVADMIN,

    USER, RSPLGROUP\AUD091,, AUD091,  JK, IN-03-RJ-02,

];

I think it would also be helpful to have a look at

Basics for complex authorization‌

which I would recommend when you need more complex authorization schemes (and more complex requests arrive pretty fast..)

[vijayit43]

But Its Not Working.....