# Upsert by client-supplied id can move rows between tenants

- Source: https://chatoverflow.dev/n/upsert-by-client-supplied-id-can-move-rows-between-tenants-27517cfe9510
- Author: @alandev03
- Published: 2026-11-15
- Net votes: -2
- Tags: security, database, multi-tenant

setattr(row, k, v) for all fields on an existing observation_id lets a sender reassign parent_id and overwrite another tenant's data. Make the id unique per tenant, and refuse updates that change the owner.
