User is asked for credentials second time still unable to go beyond the login screen

[PavankumarL]

Hi all...h

I have a production issue that I need help on. A user can get into the Qlikview menu but once in the system she is asked for her credentials a second time and can’t get beyond that screen…

Please help me to fix the issue ... Thanks in advance.

 

[vinieme12]

 The App has section access defined  with User and Password columns, you just need to use NTNAME, remove password from section access

[Daniele_Purrone · Accepted solution]

Hi @PavankumarL 

the login form you are seeing is a Section Access login form, which a security feature specific to the application. As @vinieme12 wrote, you will need to make sure that she is added to the document's section access table. If you want her to just come in as her active directory user, without having to enter a passwor d, you just need to use NTNAME.
More info here  and here.

Cheers!

[PavankumarL]

hi

Thank you for your response ....

I am posting the section access code here for your reference kindly guide me through the same...

-------------------------

USERTABLE:
LOAD
RECNO() as PERSONID,
'USER' as ACCESS,
'*' as USERID,
'*' as PASSWORD,

[NT USER] as NTNAME,

Global as GLOBAL,
Divisional as DIVISION,
Divisional2 as DIVISION2,
Site1 as Site1,
Site2 as Site2,
Site3 as Site3,
Site4 as Site4,
Site5 as Site5,
Kam as KAM,
Salesrep as SALESREP,
[Sales Manager] as SM

FROM
$(QVDRoot)SEQURITY\Security.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Section Access;
STAR is *;

LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME, LEVEL1
ADMIN, QLIKVIEW2017, PASS, *,
ADMIN, *, *, QLIK,
ADMIN, *, *, QVLOAD,
USER, GLOBAL, *, *,
USER, DIVISION, *, *, 1
USER, DIVISION2, *, *, 1
USER, Site1, *, *, 6
USER, Site2, *, *, 6
USER, Site3, *, *, 6
USER, Site4, *, *, 6
USER, Site5, *, *, 6
USER, KAM, *, *, 5
USER, SALESREP, *, *, 4];

LOAD
ACCESS,
USERID,
PASSWORD,
NTNAME,
' ' as LEVEL1
RESIDENT USERTABLE
WHERE GLOBAL='Y';

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE (NOT GLOBAL='Y') and (LEN(SALESREP) > 0 or LEN(KAM) > 0);

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE LEN(DIVISION) > 0 or LEN(DIVISION2) > 0;

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE LEN(Site1) > 0 or LEN(Site2) > 0 or LEN(Site3) > 0 or LEN(Site4) > 0 or LEN(Site5) > 0;

Section Application;

--------------------------------------------

[PavankumarL]

hi

Thank you for your response ....

I am posting the section access code here for your reference kindly guide me through the same...

The particular user id is "Global"

-------------------------

USERTABLE:
LOAD
RECNO() as PERSONID,
'USER' as ACCESS,
'*' as USERID,
'*' as PASSWORD,

[NT USER] as NTNAME,

Global as GLOBAL,
Divisional as DIVISION,
Divisional2 as DIVISION2,
Site1 as Site1,
Site2 as Site2,
Site3 as Site3,
Site4 as Site4,
Site5 as Site5,
Kam as KAM,
Salesrep as SALESREP,
[Sales Manager] as SM

FROM
$(QVDRoot)SEQURITY\Security.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Section Access;
STAR is *;

LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME, LEVEL1
ADMIN, QLIKVIEW2017, PASS, *,
ADMIN, *, *, QLIK,
ADMIN, *, *, QVLOAD,
USER, GLOBAL, *, *,
USER, DIVISION, *, *, 1
USER, DIVISION2, *, *, 1
USER, Site1, *, *, 6
USER, Site2, *, *, 6
USER, Site3, *, *, 6
USER, Site4, *, *, 6
USER, Site5, *, *, 6
USER, KAM, *, *, 5
USER, SALESREP, *, *, 4];

LOAD
ACCESS,
USERID,
PASSWORD,
NTNAME,
' ' as LEVEL1
RESIDENT USERTABLE
WHERE GLOBAL='Y';

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE (NOT GLOBAL='Y') and (LEN(SALESREP) > 0 or LEN(KAM) > 0);

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE LEN(DIVISION) > 0 or LEN(DIVISION2) > 0;

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE LEN(Site1) > 0 or LEN(Site2) > 0 or LEN(Site3) > 0 or LEN(Site4) > 0 or LEN(Site5) > 0;

Section Application;

--------------------------------------------