Forum Discussion
Row Level Security vs Parameter
Hi , I currently have the same report for 10 different customers and just change a parameter at the top of the SQL for each customer. Can this be done in a more efficient way using Row level ...
lherbert501 yes you can surely use RLS, load all the data, and apply row-level security based on the logged-in user. There are tons of blog posts that you can google search on how to implement it. it is pretty straightforward.
Hi parry2k, okay thanks. I know RLS can work with users in the same business, but I didn't know if it was the right way to go if its different customers in this case, as they're not logged in users and just access via a URL.
Thanks Liam