Need Help to resolve the problem of Section Access

[#1]

Hi,

i have a problem with the security in qlikview.

i need in my application to create an authentication field for users. here is what a did.

Users:
Load * Inline [
PK_Users,US_Id, US_IsAdmin, QVLogin,US_UserName, US_PASSWORD, US_DateInsert, US_UserInsert,US_OMIT
1,1,ADMIN,test1,test1,123,*
2,2,USER,test2,test2,123,*
];

RIGHT JOIN

LOAD PK_Users ,
US_Id ,
US_IsAdmin ,
QVLogin,
US_UserName,
US_PASSWORD,
US_DateInsert,
US_UserInsert,
US_OMIT

FROM QVD_Secure_Acces.qvd (qvd) ;

TSecurite:
LOAD
PK_Users as T1,
US_IsAdmin as T2,
QVLogin as T3,
US_PASSWORD as T4,
US_OMIT as T5
FROM QVD_Secure_Acces.qvd (qvd);

Section Access;

NEWUSER:
Load
T1 as PK_Users,
T2 as ACCESS,
T3 as USERID,
T4 as PASSWORD
Resident TSecurite;

TestSecurite:
LOAD * Inline
[
PK_Users,ACCESS,USERID,PASSWORD,OMIT
1,ADMIN,test1,test1,*
2,USER,test2,test2,*
];

i can't identify the problem here. it seems work fine but no.

when i try to connect with a new user that i create in the application. the authentication fail.

Please i need Help !!!

[timmy]

Document Settings => Tab: Opening:

Initial Data Reduction Based on Section Access => Check this on and uncheck Strict exclusion

[#3]

Hi,

thank you fo your Reply.

I tried to do that. but it does not work 😞

[#4]

What i did in "Document Settings" stopped the access to the application

even with

User : test1

mdp : test1

Fortunately i have a copy someWhere 🙂