Section access reduction issue

[#1]

Hi all,

I'm experiencing an issue when using my section access script.

I'd like to reduce data (site), based on the username.

Here is my script:-

section access;

LOAD * inline [

ACCESS, USERID, REDUCTION, OMIT

USER, AUTH9\ADMIN,*,

USER, AUTH9\USER1,SITE 1,

USER, INTERNAL\SA_SCHEDULER,*,

USER, AUTH9\USER2,SITE 2,

];

section application;

DATA_TABLE:

LOAD

  *,

    UPPER(Site) as REDUCTION

RESIDENT PRE_TABLE:

So when USER1 logs in they should see only data relevant to SITE 1. So I'd like the reduction field to be linked to value = SITE 1

User 2, it should reduce for SITE 2. ie Only show SITE 2

It isn't behaving correctly and I get an access denied error when I login as either USER 1 or USER 2.

I would appreciate any ideas or tips.

Thanks

[dominicmander]

If user1 and user2 are getting access denied it might be worth double-checking that you have the user and domain right for them.

Try creating a new app with a text object with the expression =osuser() in it and then log in as user1 or user2 and open the app and see what it says.

PS. by " I get an access denied error when I log in" do you mean when you try to open the app? or before you get to opening the app, when you try to log in to the hub?