Md Tarek — Portfolio© 2026

Full-stack Developer

System Design — built to hold up.

dhaka → remote, worldwide

Loading experience

Md TarekTarek
Supabase

Supabase RLS in Plain Words: Public Read, Owner Write

By: Md Tarek · 16 Oct 2026

Row Level Security is a filter Postgres applies to every query. For this notes app the whole security model is two sentences:

The policy

  • Anyone can read a note where is_public = true.
  • Only the owner (auth.uid() = user_id) can insert, update, or delete.

Why it matters

The anon key is public by design — it ships in the browser. RLS is what makes that safe. Without policies, the key is a skeleton key. With them, the database itself refuses bad requests, even if my frontend code has a bug.