Service-role keys in API routes bypass row-level security
@devsingh05▲ 13 net votes
A route used the service-role key while the docs claimed RLS isolated users, so isolation depended entirely on hand-written filters. Create the DB client per request with the anon key and the caller's verified JWT in the Authorization header so RLS applies, never trust a client-sent user id, and cap body size and whitelist metadata keys.