Multi Tenant Architecture - PostgreSQL Row Level Security (RLS) Questions

[Apple]

@mike-f

Apple, Global steps seems like it’s the way to go for me, but does that work if url is the same for all tenants? I can see how a Global check that the correct user is in the correct page could work, but if the url is, say, www.example.com/myaccount then how would you use a Global check to enforce the correct person saw the correct data?

Hi,

I’m not quite sure how you’re implementing tenants. Regardless, everything you want is possible

Check this past reply of mine to see if it helps:

Subdomain routing for Saas

Create a test Server Action, and put there: Set Value env = {{$_ENV}} Set Value server = {{$_SERVER}} Try to find the current (sub)domain in one of those variables, so there you have how to find the current subdomain being accessed. On your DNS provider you have to make a wildcard DNS entry (like *.example.com) to point to your server’s IP address. If you click on Globals, these are Steps that run on every page. There, check the current subdomain (from variable like $_SERVER.something), do…

It’s not exactly what you want but it may help you too