Forum Discussion
Solved
Filter based on username without using row level security
Hello, - I have a table with a username and a geographic area, and users are allowed to see only particular geographic areas as well as report visuals which contain rolled up (aggregated) data fo...
that, or providing different apps to different audiences.
How would that be different from RLS?
My thinking is to create a table which is joined to the usertable to get the allowed regions, and pass the allowed regions to the rest of the dataset without using RLS. The main dataset is not joined to the table filterd by RLS. Could be my thinking is wrong though.
If anyone has ideas on how to do this would be apreciated.