make NTname in upper
LOAD ACCESS, Upper(NTNAME) as NTNAME
(html, utf8, embedded labels);
STAR IS *;
LOAD * INLINE [
upper(NTNAME) as NTNAME,
1 as j
drop table Tab1;
hope this helps
yes the user is definitely not an admin. I've tried several things and suddenly it worked. My code looks like this now:
Section Access; LOAD Upper(ACCESS) as ACCESS, Upper(NTNAME) as NTNAME, REDUCTION FROM [http://Server42:4780/QMS/AuthTable] (html, utf8, embedded labels); Section Application; STAR IS *; [AuthTable]: LOAD * INLINE [ NTNAME, Selection SERVER42\GROUP_1, Select_1 SERVER42\GROUP_2, Select_2 SERVER42\GROUP_3. Select_3 SERVER42\ADMINGROUP, * ];
On the Server I've set REDUCTION for field Selection for all USER.
It didn't work when I tried your coding Sunil but I guess you where right: with changing the Users in Section Application to upper case it started to work.
Thank you both for your help!