How to avoid authentication popup after implementing Section Access

[#1]

Hi,

I want to implement section access, based upon window authentication for that i have written below code but when the users opens the document he gets the pop up of UserId, Ideally Users must not get these pop up as users logs in to system with windows ID.

star

rename

field BR_CODE to

BRANCHCODE1;

//rename field State to STATE;

//rename field NewState1 to NEWSTATE;

//rename field City1 to CITY;

//rename field Region to REGION;

//rename field NewRegion1 to NEWREGION;

//rename field Business to BUSINESS;

//rename field Country to COUNTRY;

section

Load

//Employee_code,

//Employee_Name,

//Password1,

//Role_Code,

//Location_Type,

//Location_code,

//[USERID],

//[PASSWORD],

upper([ACCESS]) as ACCESS,

NTNAME

as USERID

//NTDOMAINSID

//SERIAL

FROM

E:\Arun\SectionAccess.xls (biff, embedded labels, table is [Employee_Master$]);

join

Load

NTNAME as USERID ,

//[USERID],

BRANCHCODE1

// CITY,

// STATE,

// REGION,

// COUNTRY,

// BUSINESS,

// [NEW STATE] as NEWSTATE,

// [NEW REGION] as NEWREGION

FROM

E:\Arun\SectionAccess.xls (biff, embedded labels, table is [EMPMAPPING$]);















access; is *;

I checked the option in Setting - Document - under General Tab- Initial Data Reduction Based on Section Access and Strict Exclusion

Thanks & Regards,

Arun

[vgutkovsky · Accepted solution]

Your code is pretty much unreadable because of the weird HTML formatting, but I think you're using USERID. Instead, use only NTNAME, which will check against the currently logged in Windows identity. So you would have the following columns: ACCESS, NTNAME. You might also need USERID and PASSWORD (which you would populate with *), but try it without it first.

Regards,