6 Replies Latest reply: Jan 9, 2018 8:36 AM by Marcus Sommer RSS

    Masking Private Data

    Fernanda Gomez

      Good morning, I have the following question, I need some fields to be masked according to the user that is logged. In case that user does not have permission to see that program he should see the fields that are not public 'Private'. The records should not be filtered because may have fields that are public and even if they can not see that program, they could see those public fields. For example the total amount of all programs.

      To evaluate if a program is public or private for the user that is logging in, you must have the same department and geography as the owner of each program. For example if the user that is logging in is from Spain and Dept1 and having a list of programs like this:

       

      Program     Owner     Geo_Owner     Dept_Owner     Amount

      Program1     Jose          Spain               Dept1               200

      Program2     Manuel      Spain               Dept2               300

      Program2     María         UK                   Dept1               400


      The user should see a table like this:

      Program     Owner     Geo_Owner     Dept_Owner     Amount

      Program1     Jose          Spain               Dept1               200

      Privado        Privado      Privado           Privado             300

      Privado        Privado      Privado           Privado             400


      I attach a qvf with 4 tables Programs, Assets, Pipeline and Users and an Excel with the table that must be output for the userA. The fields Program, AssetID and PipelineID must be evaluated to see if the data should be viewed or show 'Private', the other fields are public and should always be displayed. The owner's data is at the program level.


      Thank you very much in advance.