Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
senpradip007
Valued Contributor III

Section Access Problem

Hi All,

I need your help about this topic.

I can implement section access via Inline load or loading from Excel file.

I am using following code to load data from SQL Server

ODBC CONNECT TO dsnTest (XUserId is BWDKaZFMIC, XPassword is ZZRJLYFMTbcOXXJOELMETZUX);

SECTION Access;

LOAD

          ACCESS,

  USERID,

  PASSWORD;

SQL SELECT *

FROM Test.dbo."tbl_SectionAccess";

SECTION Application;

But when I open the application it is asking for the UserId repeatedly instead of Password.

Please help me to get rid of this problem.

UserId is "Admin

Thanx in advance.

1 Solution

Accepted Solutions
Luminary
Luminary

Re: Section Access Problem

Pradip - Are you using UPPER case? This behaviour is because Section Access can't find the User within the Section Access table. Please make sure you that you use UPPER case for all the Section Access fields. And remove Section Access and Section Application statements to check if you can load the User Name, Password etc within your data model. Also, please copy your select statement results into excel file and post it here and we can look into it.

Make sure that you include ADMIN with your Section Access Table.

I hope this makes sense!

Cheers,

DV

www.QlikShare.com

4 Replies
giakoum
Honored Contributor II

Re: Section Access Problem

I think there is no user Admin in your table or the users role is preventing him from opening the document. That is why it asks again for another user. Load the tables in section application to see which users are returned and with what access.

senpradip007
Valued Contributor III

Re: Section Access Problem

Hi

Pls check the attached file in the sql server,you can see all the information in this file.

Thanks

giakoum
Honored Contributor II

Re: Section Access Problem

sorry cannot open that file. An excel would help.

Luminary
Luminary

Re: Section Access Problem

Pradip - Are you using UPPER case? This behaviour is because Section Access can't find the User within the Section Access table. Please make sure you that you use UPPER case for all the Section Access fields. And remove Section Access and Section Application statements to check if you can load the User Name, Password etc within your data model. Also, please copy your select statement results into excel file and post it here and we can look into it.

Make sure that you include ADMIN with your Section Access Table.

I hope this makes sense!

Cheers,

DV

www.QlikShare.com

Community Browser