Section access asks for login credentials?!

[alec1982]

Hi guys,

I have the following section access to reduce data

Section Access;

LOAD NTNAME,

     NTDOMAINSID,

     [ACCESS],

     UPPER(MANAGER)&'|'& UPPER(NAME) as %AuthID

FROM

(ooxml, embedded labels, table is Sheet1);

Section Application;

and not sure why the users are able to access the access point but when they click on the dashboard it askes them for user name and Password?

Any idea?

Thxs

[Anonymous · Accepted solution]

It may happen if the NTNAME login fails.

BTW, the reduction field name must be all caps, not only the values.

[alec1982]

Hi,

If I sign in as an admin with my ID everything works.. so I am assuming there is no issues with the fields, right?

when I try to login on one of the users machine I get question for username and password even the user accessed the access point.

[#4]

if you sign in as ADMIN even your reduction field doesn't match, it  will allow you to open. Reduction field name must be in caps.

[Anonymous]

Besides, always use upper() function in section access, unless you use inline load.  Even if you know that the data is in upper case already.

Section Access;

LOAD

     upper(NTNAME) as NTNAME,

     upper(NTDOMAINSID)  as NTDOMAINSID,

     upper(ACCESS) as ACCESS,

     UPPER(MANAGER)&'|'& UPPER(NAME) as AUTHID

FROM

(ooxml, embedded labels, table is Sheet1);

Section Application;