2 Replies Latest reply on Mar 21, 2016 6:22 AM by pulkit jain

    Multiple type user securty

    pulkit jain

      I need to apply row level security based on type of user as follows:

      1. Super user to show all data

      2. Hr's to show only there country data

      3. General user to show rows having his ID only.

       

      I have a lookup table as

      emp_id, country, flag (to define what kind of user it is)

       

      and I have data table as

      emp ID, country, measure1 etc

       

      I have tried data blending. but for each type of user I am able to put security(one level at a time).

      though when I try to put all three type in one report I am not able to do it..