In section access file if USER is specified getting access denied message but works for ADMIN

[Saranya1]

Section access script as follows:

Section Access;

LOAD
UPPER("ACCESS") as ACCESS,
UPPER(USERID) as USERID,
Upper(Region) as Region,
Upper(Country) as Country,
Upper(LOB) as LOB
FROM [lib://$(vConnection)/Section Access.xlsx]
(ooxml, embedded labels, table is [User Access]);

Section Application;

My section access file looks like:

ACCESS	USERID	Region	Country	LOB
ADMIN	INTERNAL\SA_SCHEDULER	ALL	ALL	ALL
USER	domain\username	ALL	ALL	ALL

[henrikalmen]

Do you have fields in your data model named Region, Country and LOB and in those fields you have the value "ALL"?

Try removing Region Country and LOB so that you only have ACCESS and USERID. If it works, you can start experimenting with the reduction fields.

(I assume "domain\username" is just an example, and that you have actual usernames there.)