Re: [sqlalchemy] Postgres Row Level Security (RLS)

2021-03-04 Thread Open Ocean
on in your applicaiton that is given > the operations context and then runs the required functions, then Alembic > version files can import that function and run it as needed. > > > On Thu, Mar 4, 2021, at 12:21 PM, Open Ocean wrote: > > I'm trying to figure out how to a

[sqlalchemy] Postgres Row Level Security (RLS)

2021-03-04 Thread Open Ocean
I'm trying to figure out how to add RLS to tables using sqlalchemy and alembic. I'm changing from schema per tenant to row per tenant in a multi-tenant db. My approach is: - use pg setting 'tenant.id' to identify the current tenant - add tenant column to tables with server_default=func.current_