Any interest in supporting Postgres RLS (row level security)?

Finbuckle / Finbuckle.MultiTenant

Finbuckle.MultiTenant is an open-source multitenancy middleware library for .NET. It enables tenant resolution, per-tenant app behavior, and per-tenant data isolation.

https://www.finbuckle.com/multitenant

Apache License 2.0

1.26k stars 261 forks source link

Any interest in supporting Postgres RLS (row level security)? #730

Open jtanios opened 11 months ago

jtanios commented 11 months ago

Adding security at the row level greatly enhances tenant isolation and eliminates the need for query filtering.

I have a working prototype of the solution.

AndrewTriesToCode commented 10 months ago

Hi, I would be interested -- probably as part of a new package. Does it integrate with EFCore? I'm not a Postgres expert but I can see why it would be useful.

jtanios commented 2 months ago

Yes, it uses DbConnectionInterceptor and NpgsqlMigrationsSqlGenerator to implement RLS.

What would be the best way to add this functionality? Create a new package that uses Finbuckle.Multitenant?