You're using 10% of Postgres RLS: FORCE RLS, security_invoker and more
_jaydeepkarale · x · 2026-11-19
Most teams write one tenantid RLS policy and stop. This thread covers the rest: FORCE ROW LEVEL SECURITY to stop owners bypassing rules, passing tenant IDs via session state, securityinvoker = true (Postgres 15+) so views check RLS as the caller, and wrapping tenant lookups in (SELECT ...) so policies run once per query.
More from coding & agent
- Human Principal launches private beta: cryptographic proof a human is behind your AI agent — yenkel · 2026-11-19
- GPT-6.2 builds code-only 3D fairy town and a deep-sea civilization in 10–20 minutes — OpenAIDevs · 2026-11-19
- Designers are being asked to do interior design while ignoring the architecture — round · 2026-11-19
- Dev builds a playable FPS in under 5 hours with GPT-6.2 and Unreal Engine 5.9 MCP — OpenAIDevs · 2026-11-19
- Stop vibe coding: a 7-step AI coding workflow from AGENTS.md to hooks — _jaydeepkarale · 2026-11-19
- Why you should always build your own LLM proxy: auth, caching, cost visibility — viksit · 2026-11-19