Skip to content

Topic

Row-Level Security

A database security feature restricting which rows a query can access via policies, used for per-tenant isolation in Postgres platforms like Supabase.

Current stories

buildConfirmed2 publishers

Anthropic and OpenAI fund separate firms to station engineers inside customers

Anthropic and OpenAI have each capitalized a separate services firm, $1.5 billion and over $4 billion, to embed engineers in enterprises. Wing partner Tanay Jaipuria treats that as evidence of an integration bottleneck.

Publishers:tanayj.com thedatavist.substack.com

Reality

Evidence40
Adoption30
Hype gap+25
Incentives70
Confidence45
buildOne report1 publisher

Supabase's grants-based 42501 reaches existing projects after October 30, a post says

A dev.to author says Supabase's 42501 error from missing table grants will show up on existing projects after October 30, 2026. Adding an RLS policy does not clear that case, the author reports from local-stack tests, so telling it from the three policy causes means reading the message text.

Publishers:dev.to

Reality

Evidence68
Adoption
Not scored
Hype gap−5
Incentives
Not scored
Confidence65
buildOne report1 publisher

Supabase turns off automatic Data API exposure for new tables on every existing project on 30 October

Supabase will stop exposing new public-schema tables to its Data API automatically on all existing projects on 30 October 2026. Tables created after that date stay invisible to supabase-js until a role is granted access.

Publishers:dev.to

Reality

Evidence55
Adoption
Not scored
Hype gap
Not scored
Incentives
Not scored
Confidence60
buildOne report1 publisher

Supabase's new API default skips the existing tables behind UpGuard's 16,326 readable databases

UpGuard found 16,326 Supabase databases with readable tables in a scan of roughly 300,000 domains. Supabase's new default keeps new tables off its APIs, but older tables keep their grants until owners review them and their row-level security.

Publishers:runtimewire.com

Reality

Evidence55
Adoption35
Hype gap+10
Incentives50
Confidence55
buildOne report1 publisher

Supabase's Oct 30 grant change leaves tables unreachable in 98 of 100 replayed migration histories

Ninety-eight of 100 public Supabase migration histories leave a table the Data API cannot reach once automatic grants end on Oct 30, a dev.to replay found. Existing tables keep their grants, so the failures land on new tables and on environments rebuilt from those files.

Publishers:dev.to

Reality

Evidence55
Adoption5
Hype gap+10
Incentives
Not scored
Confidence60
buildOne report1 publisher

Amazon Quick apps re-run agent-written SQL on governed Quick Sight data each time a viewer opens them

Amazon Quick's AI-built apps now query governed Quick Sight datasets, in SPICE or Direct Query mode, each time someone opens them. Queries run under the viewer's identity, so the row- and column-level rules already on a dataset decide what each person sees.

Publishers:aws.amazon.com

Reality

Evidence45
Adoption
Not scored
Hype gap+20
Incentives80
Confidence55
buildOne report1 publisher

Moving a browser-queried Supabase app shut all 228 RLS policies until auth.uid() moved too

One developer moving a 99-table SaaS off Supabase Cloud saw all 228 row-level security policies fail silently until auth.uid() moved with the database. Any app that queries Postgres from the browser has to bring its auth and session layers across in the same cutover.

Publishers:dev.to

Reality

Evidence55
Adoption
Not scored
Hype gap+5
Incentives
Not scored
Confidence50
buildOne report1 publisher

Lovable-built apps and Moltbook leaked through database rules that were missing or wrong

Matt Palmer's scan found 170 of 1,645 Lovable showcase apps leaking data through inadequate Row Level Security, the same kind of gap Wiz found at Moltbook. Before launch, an AI-built app needs a review that tests the database rules behind its public key.

Publishers:dev.to

Reality

Evidence50
Adoption
Not scored
Hype gap0
Incentives35
Confidence55
securityOne report1 publisher

UpGuard finds more than 16,000 Supabase databases left readable through missing row-level security

UpGuard found more than 16,000 Supabase databases exposing readable tables of personal data, passwords and authentication tokens. It blames row-level security and key settings that each project's owner controls, so every app needs its own fix.

Reality

Evidence50
Adoption60
Hype gap+20
Incentives50
Confidence55
buildOne report1 publisher

Checking membership inside Postgres policies closes a 15.5-minute revocation gap in a no-backend app

Row-level security in a no-backend Neon app refused 27 of 27 tenant attacks, yet a removed member read on for 928 seconds. A membership check in the policies closed that gap at a cost of about 5 ms on function calls.

Publishers:dev.to

Reality

Evidence55
Adoption
Not scored
Hype gap0
Incentives
Not scored
Confidence55
buildOne report1 publisher

Where the check lives decides how far a wrong agent write travels

Sanity blocks published writes by API default, Notion records Custom Agent runs in its Enterprise audit log, and Supabase tells developers to keep its MCP server off production. None of the three tests whether the value is right.

Publishers:dev.to

Reality

Evidence56
Adoption38
Hype gap+14
Incentives72
Confidence52
buildOne report1 publisher

Co-locating embeddings with permissions collapses the RAG fetch into one SQL statement

A dev.to walkthrough builds the whole retrieval path on pgvector and the azure_ai extension inside Azure Database for PostgreSQL. The costs land in the DDL, the extension allowlist, and a transaction that waits on an HTTP call.

Publishers:dev.to

Reality

Evidence42
Adoption
Not scored
Hype gap+28
Incentives55
Confidence55
buildOne report1 publisher

Lovable's security scanner clears an RLS policy that returns every customer's orders

A Row Level Security policy can pass Lovable's scanner, restrict itself to authenticated users, join a membership table, and still hand every order in the database to anyone who signs up. Two SQL queries find it.

Publishers:dev.to

Reality

Evidence60
Adoption38
Hype gap+18
Incentives35
Confidence55
buildOne report1 publisher

A flat tenant_id forces the three workarounds that ship cross-tenant leaks

A checklist written by someone who sells generated multi-tenant backends dates the tenant model and the source of tenant identity to day one, and the database isolation argument to the first paying customer. The author then runs the test on their own product.

Publishers:dev.to

Reality

Evidence42
Adoption
Not scored
Hype gap−10
Incentives70
Confidence52
buildOne report1 publisher

Text-to-SQL demos test the one part of the job that stopped being hard

A buyer's checklist published on dev.to puts accuracy measurement and permission enforcement ahead of the live demo, and every question on it comes with a test you can run inside the meeting. Its author sells in the category.

Publishers:dev.to

Reality

Evidence45
Adoption
Not scored
Hype gap+15
Incentives75
Confidence45
buildOne report1 publisher

The polling fix for a dead WebSocket only reads ten blocks every fifteen minutes

A developer's Aave liquidation monitor went silent five minutes into a free-tier Alchemy WebSocket. The getLogs loop written to replace it samples ten blocks on a fifteen-minute timer, so most blocks are never read.

Publishers:dev.to

Reality

Evidence40
Adoption8
Hype gap+35
Incentives25
Confidence55
buildOne report1 publisher

RLS Is a Planner Problem: One VOLATILE Function Turns a 3ms Index Scan Into 1.8 Seconds

A dev.to tutorial benchmarks naive multi-tenant Row-Level Security at roughly 575 times slower than no policy at all. The variable is function volatility, not schema or traffic.

Publishers:dev.to

Reality

Evidence36
Adoption
Not scored
Hype gap+22
Incentives62
Confidence47