1 Reply Latest reply: Feb 26, 2016 4:21 AM by Dominic Mander RSS

    Section access reduction issue

    coco jackson

      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

        • Re: Section access reduction issue
          Dominic Mander

          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?