2 Replies Latest reply: Dec 22, 2012 3:33 PM by Jennie Staples RSS

    section access in order to reduce/restrict data based on roles

    Jennie Staples

      I have a dataset loaded into QV that has full data for the entire workforce since 2003.  I want to give individual users within their affiliations access to THEIR history and THEIR history ONLY.

       

      New roles have been created to drive this security:

      Sample Affiliation roles
      HDW^HRA^TUB^Comp^BUS
      HDW^HRA^TUB^Comp^SPH

       

      Sample Empl_Type roles
      HDW^HRA^TUB^Comp^EmplAll
      HDW^HRA^TUB^Comp^EmplStaff

       

      Within the dataset, there  is a field called “Access_Affiliation” and another called  “Access_Empl_Type.”

       

      HERE IS WHAT I WOULD LIKE:

       

      1. user needs two roles (one Affiliation role and one Empl_Type role) to see this section.
      2. The specific role will drive specific access


      a. somebody with the roles below should be able to see only SPH affiliation for all employee groups.
                      HDW^HRA^TUB^Comp^SPH
                      HDW^HRA^TUB^Comp^EmplAll
      b.  somebody with the roles below should be able to see the BUS affiliation and staff only.
                      HDW^HRA^TUB^Comp^BUS
                      HDW^HRA^TUB^Comp^EmplStaff

       

      I think I need to add a LOAD * INLINE statement like this, but it doesn’t work:

       

      LOAD * INLINE [
      RightsGroup, Access_Affiliation
      HDW^HRA^TUB^Comp^BUS, BUS
      HDW^HRA^TUB^Comp^SPH, SPH
      ]

       

      LOAD * INLINE [
      RightsGroup, Access_Empl_Type
      HDW^HRA^TUB^Comp^EmplAll, All
      HDW^HRA^TUB^Comp^EmplStaff, Staff
      ]