Forum Discussion

majdkaid22's avatar
majdkaid22
Helper V
9 years ago
Solved

Row level security exempt

Hi guys,

 

I've started applying RLS for Sales users, so data in all tables drill down to see only their figures/statistics. 

 

My filter is simple. [user_name]="value" which I have applied for all users and did the test role and it worked as expected. 

 

However my issue is with the rest of the users (senior Management) as I want them to be exempt, and where they are able to see all the data. 

 

Now I have Sales users being able to see their own data, but the rest of the users getting a message of "You don't have access becuase RLS was applied"

 

Is there any quick workaround here I can do here to exempt particular users from the RLS?

 

 

Appreciated,

Need Help
  • majdkaid22's avatar
    majdkaid22
    9 years ago

    Anonymous ibarrau 

     

    So once RLS mode in place, a role has to be created to each user/department. 

     

    In my case I had definded roles to only Sales users (users[user_name]= "Sales Name")

    As a workaround, I just created a conditional column (users[SeniorManagement] which has a value of "SM" to all sales users, and then created a role SM (users[SeniorManagement]= "SM") and then I added all SM users so they can see all the data 

     

     

    Thanks for your respond guys.

     

    Cheers,

    Majd

5 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    9 years ago

    It seems to be that those users getting the error are not PRO users. Because if they where, they should see all data even if you add them a role, they should see something.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Once you publish online, you have to go to the dataset and click on Security, then add the users to the roles you've created in Desktop. Have you done that yet?

      • majdkaid22's avatar
        majdkaid22
        Helper V
        9 years ago

        Anonymous ibarrau 

         

        So once RLS mode in place, a role has to be created to each user/department. 

         

        In my case I had definded roles to only Sales users (users[user_name]= "Sales Name")

        As a workaround, I just created a conditional column (users[SeniorManagement] which has a value of "SM" to all sales users, and then created a role SM (users[SeniorManagement]= "SM") and then I added all SM users so they can see all the data 

         

         

        Thanks for your respond guys.

         

        Cheers,

        Majd