@Michael04_06 Good list. Two things I'd add:
RLS on ≠ RLS working. Test with two users: user B shouldn't be able to read or edit user A's rows.
New tables need explicit grants now, or you get 42501 permission denied even with perfect policies.
@XkaiiStudio For me the first thing to break wasn't syntax or trigger timing, it was missing grants. RLS on, policy fine, still 42501 permission denied, because Supabase no longer auto-grants new tables to the API roles. Grants and RLS are separate layers.
@Savelsberg_ Building a supabase + Express starter which is RLS tested and updated to the supabase 30 Oct grant , why build something again and again for your main MVP ?
Link :
https://t.co/xAGqFg81Qb
@DEVIN__SETH Made a supabase+expressjs starter , which has RLS tested instead of just "enabling" RLS , and have been updated to supabase 30 Oct grant and I release new updates with fixes .
Want it ?
Link :
https://t.co/xAGqFg81Qb
@Seanwvibedev I am building a Supabase+Express js starter backend , how is it different from other starters ? Mine doesn't promise RLS is enabled I have tested it's RLS and updated it to the supabase 30 Oct grant .
Wanna know more about it ?
Link ; https://t.co/xAGqFg8zFJ
@Joi2James Building a Supabase+Express js starter backend that is RLS tested unlike other starters saying "RLS enabled " .
Link :
https://t.co/xAGqFg81Qb
@Gaus450 People can make money but only if they use there technical expertise aswell , instead of saying "Fix this make no mistakes " and market the app .
Every MVP I start needs the same things: signup, login, password reset, a /me route, JWT middleware.
I packaged them once so I don't rewrite them again.
Want this for your self aswell?
Check the links in reply 👇
#supabase#PostregeSql#Sql#Security
Supabase stopped auto-granting new public tables to the API roles.
If your tables suddenly throw 42501 permission denied, you're missing explicit grants. Grants and RLS are separate layers, and you need both.
#webdev#supabase#Security
2 (problem)
Most starters say "RLS enabled."
Few prove it.
Mine ships test-rls.js: two users, one command, checks that cross-user reads and edits fail.
Enabled ≠ enforced.
Link below 👇
#postreges#supabase#security#webdev
Built a Supabase + Express starter because I was tired of rebuilding auth for every MVP.
The part I care about most: a two-user test that checks User B can't read or edit User A's data.
5 PASS lines, one command.
Link in replies 👇
#postreges#supabase#security
Don't return your auth providers Raw Error message to the client
"Email not confirmed " vs "invalid credentials " tells an attacker which email have accounts .
Return 1 generic message. Log the real one server side .
#supabase#postreges#rls#expressjs