Does OSO work with Row Level Security in Postgres+SQLAlchemy-OSO?

[radiantone]

Hi, I use oso and sqlalchemy-oso with postgres. I want to use Postgres' RLS (Row Level Security) but not sure if OSO can work properly with that enabled.

Thanks

[dhatch]

Hi @radiantone, sqlalchemy-oso will work with RLS, but there is not an integration with it. So, your queries in SQLAlchemy would have RLS applied as they would if you were only using sqlalchemy. When you use sqlalchemy-oso, you'd get additional filtering from your Oso policy on top of RLS.

Could you expand a bit more on what you're looking to achieve by using both Oso and RLS?