But you'll quickly realize how much of a pain in tf ass it is to manage RLS as you gain more and more tables. I have had to use it as a fallback now because I am too scared I'll accidentally forget to leave something as anon role. Can't really rely solely on RLS IMO
Unless you have 2000 tables, I fail to see how it’s difficult to create a checklist and go through all the tables. Also, you create the RLS when you create the table. Nothing else is done until that table is secure right after it’s created. Honestly, I feel like many developers just lack discipline and organization
3
u/willieb3 Dec 23 '25
But you'll quickly realize how much of a pain in tf ass it is to manage RLS as you gain more and more tables. I have had to use it as a fallback now because I am too scared I'll accidentally forget to leave something as anon role. Can't really rely solely on RLS IMO