Multi tenant single database

[laurent512]

Hello,

I am building a SaaS which has to be multi tenant within a single database for cost efficiency reason.
My schema includes a Tenant table containing all the tenants with their Id , name and others props.
All the other models have a tenantId prop.

It means that in each update query for example, there is a where clause mentionning the relevant tenantId.
It creates a big security failure point if a dev forgets to specify the where clause.

Would there be a solution to enforce at database level that protection? Or during the connection process to the db ?
I am not an expert so I don't have any clear idea or implementation in mind but I would be curious if neon could provide such service :)

Thank you so much :)

[laurent512]

Any idea or suggestion? :)