Forum Discussion

javier-martinez's avatar
javier-martinez
New Member
3 years ago
Solved

Row Level Security Issue

Hi everyone,   I'm facing a problem applying a Row Level Security to my report. I have create a Rol where I filter the Countries depend on the user email. And when I click on test a role it ...
Dynamic Role
RLS
Rol
Roles
Row Level Security
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, javier-martinez ;

    This is probably happening because the user (test user) has access to the workspace as either an Admin, Member or Contributor. These Workspace users are NOT subject to RLS so will see all data. You need to user to be a "Viewer" in the Workspace to be subject to RLS. Go to the Access options in the workspace and set the test user to "Viewer".
    if not right,can you share your simple data and result what you want to output?


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, javier-martinez ;

This is probably happening because the user (test user) has access to the workspace as either an Admin, Member or Contributor. These Workspace users are NOT subject to RLS so will see all data. You need to user to be a "Viewer" in the Workspace to be subject to RLS. Go to the Access options in the workspace and set the test user to "Viewer".
if not right,can you share your simple data and result what you want to output?


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.