2 Replies Latest reply on Apr 3, 2018 9:07 AM by kamran munib

    Row level security

    kamran munib

      how low level security is implemented? I wanted to know how a user can only see the data related to his organization? Where is the low level security maintained?

        • 1. Re: Row level security
          Emanual Henry

          I'm in a call center setting.  So we have Agents, Supervisors, Managers, etc.  We started in SQL. 


          1.) We created a field which contained delimited NT Logins of the user up through his hierarchy.



                    Employee_hierarchy_NT = Joe.Schmoe, John.Doe, William.Thatcher, Jane.Doe


          2.) We created a calculated field. 



          3.) Add this calculated field to your filter where = TRUE.


               Alternately, we used a parameter to let users decide if they want to see all the data or the data that is relevant to them.

                    IF [Display] = 'My Team'

                        AND CONTAINS(lower([Employee_hierarchy_NT]),lower(USERNAME())) THEN 1

                    ELSEIF [Display] = 'Everyone' THEN 1


          1 of 1 people found this helpful
          • 2. Re: Row level security
            kamran munib

            Thanks alot