QuickDevGuide

Home › PostgreSQL Database

Row Level Security (RLS) — PostgreSQL Database

Row Level Security (RLS) lets you define policies that control which rows a user can see or modify. The database enforces these rules transparently — application code doesn't need to add WHERE clauses. How RLS Works Enable RLS on a table: ALTER TABLE ... ENABLE ROW LEVEL SECURITY Create policies that define access rules for SELECT, INSERT, UPDATE, DELETE PostgreSQL automatically appends policy conditions to every query Policy Types PERMISSIVE (default) — Multiple permissive policies are OR'd together RESTRICTIVE — AND'd with permissive policies (additional filter) Use Cases Multi-tenant applications — Each tenant sees only their own data Role-based access — Admins see all; users see only their records Data privacy compliance — GDPR, HIPAA Supabase — RLS is the primary security mechanism…

Key Takeaways