4 Replies Latest reply: Aug 11, 2015 10:21 AM by Borja Rodriguez RSS

    User Exclusive Data

    Donish Nasim

      Hello,

      I was curious as to whether there was a way to make various data on a sheet invisible to certain users. For example if I have a dashboard for sales reps with their sales numbers and I only want them to be able to view their data and not anyone else's, would that be possible through security rules? If so how?

        • Re: User Exclusive Data
          Sinan Ozdemir

          Hi,

           

          You can accomplish this by using Section Access feature:

           

          Here is the sample code in the Main tab - make sure that the field and column values which are based on user access are capitalized:

          Capture.PNG

           

          First - go to Document Properties and check both "Initial Data Reduction Based on Section Access" and "Prohibit Binary Load":

          Capture.PNG

          Second - Insert "Section Access" code by using "Load Inline" Statement:

          From the below, you can see that I granted each user different access based on their names and mind that the column and field values are capitalized.

          Capture.PNG

          Then save the document and close it. When you open it again, it will ask you to enter a password:

          Capture.PNG

          In this case, I type PASS1 which is John's password and John can only see his sales figures:

           

          Capture.PNG

          I am also attaching the qvw.

           

          Hope this helps.