1 Reply Latest reply: Jan 30, 2012 12:48 PM by Stefan Wühl RSS

    OMIT multiple fields

      Hi,

       

      I am successfully protecting a particular data field (PROTECTEDFIELD1) from unauthorised access by certain users, by using section access in my script:

       

      SECTION Access;

      LOAD ACCESS,

           NTNAME,

           OMIT

      FROM

      [My security spreadsheet.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      In my spreadsheet I have the following table:

       

      ACCESSNTNAMEOMIT
      ADMINMYDOMAIN\GOD_USER
      USERMYDOMAIN\LOWLY_EMPLOYEEPROTECTEDFIELD1


      This works fine. When logged in as LOWLY_EMPLOYEE, I can't see PROTECTEDFIELD1.

       

      My problem is: I can't figure out how to restrict access to more than one field. Is there a particular syntax? I have tried:

      • PROTECTEDFIELD1 PROTECTEDFIELD2
      • PROTECTEDFIELD1, PROTECTEDFIELD2
      • PROTECTEDFIELD1; PROTECTEDFIELD2

       

      Any ideas?

       

      Thanks