Re: Section Access and Access Point - Qlik Community

Anonymous · ‎2017-10-13

Hey everyone,

I have been having difficulty moving a Qlikview application with access point from dev -> production (Access Point). I have successfully partitioned access to users using Section Access and confirmed using test values. However, when I go to load the application on QMC Server the task errors out when I try and run it.

I've looked back on some posts and it seems that this was a problem years ago, does anyone have or heard of a solution for this problem yet?

Thanks for your help.

pradosh_thakur · ‎2017-10-13

Have you added the service account user as admin in the section access script? Are you using username password or ntname authentication?

Share the section access script if possible.

Regards

Pradosh

Learning never stops.

Anonymous · ‎2017-10-13

No I have not added a service account user as admin, how do I do that?

I am using username password...

Section access;

LOAD ACCESS,

UPPER(USERID) AS USERID,

UPPER(PASSWORD) AS PASSWORD,

REDUCTION AS [DISTRIBUTOR NO]

FROM [..\QVD\SectionAccess.QVD] (qvd)

WHERE 1=1;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, DISTRIBUTOR NO

ADMIN, ADMIN, LYCOMING, <ALL>

USER, USER1, DIST1,3397

etc...

];

pradosh_thakur · ‎2017-10-13

Ask for your service account user name and use it in the inline load. It should be domain name /sa name. Use * instead of all use upper( reduction field)

Learning never stops.