4 Replies Latest reply: Jun 5, 2013 11:55 AM by Jareb Patriquin RSS

    Multiple Section Access

    Jareb Patriquin

      I need help with a Section Access issue. My current setup is working fine with the Section Access Table being sourced from Publisher in my script, depending what priviledges you have, you will only see certain warehouses.

       

      On top of that I need to get a second Section Access table to be controlling the data access on the rep level. I tried to add a second section access table and it doesnt work. Tried using the same but with added column and tried a new Section Access Table....same results.

       

      I've read here on the community that only one Section Access Table is allowed? Is this correct?

       

      Here is sample of the script:

       

      Section Access;
      LOAD ACCESS, NTNAME, OMIT, GROUP, CRMSALESOFFICE
      FROM [http://qvs01:4780/QMS/AuthTable] (html, utf8, embedded labels, table is [Business Overview]);
      Section Application;
      SecurityLink:
      Load * Inline [
      GROUP, Sales Office Name
      ALL, DAR, 
      ALL, MON, 
      ALL, OTT, 
      ALL, TOR,
      ALL, LON,
      ALL, WPG,
      ALL, EDM,
      ALL, CAL,
      ALL, VAN,
      ALL, NAT,
      ALL, SER,
      BRANCHMNGRS, DAR,
      BRANCHMNGRS, MON,
      BRANCHMNGRS, OTT,
      BRANCHMNGRS, TOR,
      BRANCHMNGRS, LON,
      BRANCHMNGRS, WPG,
      BRANCHMNGRS, EDM,
      BRANCHMNGRS, CAL,
      BRANCHMNGRS, VAN,
      BRANCHMNGRS, SER,
      BRANCHMNGRS, CAL,

      ]
      ;

       

      I want another one for reps like:

       

      Section Access;
      LOAD ACCESS, NTNAME, OMIT, GROUP, CRMSALESOFFICE
      FROM [http://qvs01:4780/QMS/AuthTable] (html, utf8, embedded labels, table is [Business Overview]);
      Section Application;
      SecurityLink:
      Load * Inline [
      GROUP, Sales Rep
      Some Rep, Some Rep,

      ]; 

       

      Thanks,