Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
PavankumarL
Contributor II
Contributor II

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

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.

 

Screenshot_2022-04-13-20-37-54-67.png

 

Labels (2)
1 Solution

Accepted Solutions
Daniele_Purrone
Support
Support

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!

 

Daniele - Principal Technical Support Engineer & SaaS Support Coordinator at Qlik
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
vinieme12
Champion III
Champion III

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Daniele_Purrone
Support
Support

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!

 

Daniele - Principal Technical Support Engineer & SaaS Support Coordinator at Qlik
If a post helps to resolve your issue, please accept it as a Solution.
PavankumarL
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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;

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