6 Replies Latest reply: Mar 17, 2015 3:55 PM by Mindy Kay RSS

    Section Access and Sheet Permissions

      I've been unsuccessful in creating section access and sheet permissions. This is what I've gotten so far.  Could someone please help?

       

      Thanks,

      Mindy

       

      Section Access (example):

      OSUserAccess
      ORLANDO\disneywadmin
      ORLANDO\mousemuser
      ORLANDO\duckduser
      etc.......

       

      Sheet Permissions (example):

      OSUserSH_UserGuideSH_MgmtSH_AcctgSH_Parksetc...
      ORLANDO\disneyw1111
      ORLANDO\mousem1101
      ORLANDO\duckd1001
      etc......

       

       

      SECTION Access;

       

      LOAD

        OSUser,

        Access

      From

        [G:\East\Development\Data Files\Security.xlsx]

        (ooxml, embedded labels, Table is SectionAccess);

       

      SECTION Application;

       

      SheetPermissions:

      CROSSTABLE (SheetName, SheetAllowed, 1)

      LOAD

        OSUser,

        UserGuide,

        SH_Mgmt,

        SH_Acctg,

        SH_Parks

      From

        [G:\East\Development\Data Files\Security.xlsx]

        (ooxml, embedded labels, Table is SheetPermissions);

       

       

      For the Sheet Properties [SH_Mgmt] General Conditional code...

      = sum({SheetName={'SH_Mgmt'}, OSUser()}>} SheetAllowed) > 0

       

      I also have the "Initial Data Reduction Based on Section Access" box selected along with the "Strict Exclusion" box.