8 Replies Latest reply: Sep 10, 2015 10:28 PM by Jonathan Poole RSS

    Trouble with section access

    Donish Nasim

      I've been trying to create a section access rule for SalesReps to only see their data. I can't seem to get it to work. What am I doing wrong?

       

      SR:

      LOAD

          SalesRep,

          Data

      FROM [lib://Path To My File.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      SalesRep:

      LOAD UPPER(SalesRep) as SALESREP, Data

      Resident SR;

      DROP TABLE SR;

       

      Section Access;

      LOAD * inline [

      ACCESS, USERID, SALESREP

      USER, DOMAIN\NAME, DOMAIN\NAME

      USER, DOMAIN\NAME, DOMAIN\NAME

      ];

      section application;