1 Reply Latest reply: Feb 19, 2010 11:14 PM by Rakesh Mehta RSS

    Trouble implementing Section Access

      Hi all -

      I'm having a bit of trouble getting Section Access to properly reduce the data on initial load. I have the "Initial Data Reduction Based on Section Access" box checked, and "Strict Exclusion" also checked. I'm using QV 9.0 and only opening the document on my local machine using a Developer License, not from the server. Here's what a portion of my code looks like:

       


      section access;
      LOAD * INLINE [
      ACCESS, USERID
      ADMIN, ADMIN
      ADMIN, JohnDoe
      USER, JaneDoe
      ];

      section application;

      [User Exclusion]:
      SQL SELECT
      E.EmployeeName [USERID],
      E.employee_id
      FROM
      EMPLOYEES E;


      If I attempt to open the QVW as JaneDoe, it won't allow me to open it, as expected, but if I open it as "JohnDoe," I can see information related to other Employees when I should only be able to information related to one.