Section Access Problem

[senpradip007]

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.

[giakoum]

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]

Hi

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

Thanks

[giakoum]

sorry cannot open that file. An excel would help.

[IAMDV · Accepted solution]

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