Forum Discussion
RLS And authorizations
Assuming when you tested in both workspaces, they are individual datasets ( i.e not shared dataset between workspace).
If it works in Workspace Operations, but doesnt in Workspace Crew. It could be the person e.g Adam, has been assigned with a different role in a different way.
Example
In Workspace Operations, you have these members:
1. Ops_Readers - Assigned as Viewer - contains Adam
2. Adam - Assigned as Member
3. SecurityGroup2 - Assigned as Member - contains Adam
(2) or (3) will bypass RLS, and Adam will see all data.
thanks 🙂 But ....
Workspace Operations we have followings Security Groups:
OPS_Readers (Viewer) > Contains Adam
OPS_PowerUsers (Admin) > Without Adam
Workspace Crew we have followings Security Groups:
Crew_Readers (Viewer) > Contains Adam
Crew_PowerUsers (Admin) > Without Adam
There are no other security groups.