Problem with section access

joachim_boivie — Tue, 30 Aug 2011 14:13:43 GMT

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?

topic Problem with section access in QlikView