Problem with section access

[joachim_boivie]

Hi,

i was running section access on QV 10 SR1 and upgraded to SR3 (and also a new environment). Now it has stopped working.

I do the following, (for reducing countrycode for specific users)

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, NTDOMAINSID, COUNTRYCODE

    ADMIN, mydomain\qlikview.admin, S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX,

];

Concatenate

LOAD

    UPPER([ACCESS]) AS ACCESS,

    UPPER(NTNAME) AS NTNAME,

    UPPER(S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX') as NTDOMAINSID,

    UPPER(COUNTRYCODE) AS COUNTRYCODE

FROM

[..\1. Data source\SectionAccess.xls]

(biff, embedded labels, table is [sectionaccess$]);

But as I wrote above, this code is not working. If I trying to open the document as a user from the xls file I will be denied access.

Any ideas?