RLS State Filter

[eltico21]

🏷️ Discussion Type

Question

💬 Feature/Topic Area

Code quality

Discussion Details

Im building a car tracking app

I'm using RLS security wise

So, now that that's known

I need to isolate states, so if I select NY, I shouldn't be able to see cars from NJ for example, how do I achieve this filter policy?

[jalonsea]

Tie the RLS policy directly to a State column in your users/drivers profile table.

I'd also recommend to leave a column set for maybe Counties or Cities, to also leave doors open for expanding the filter feature in the future.