supabase / splinter

Supabase Postgres Linter
https://supabase.github.io/splinter/
68 stars 6 forks source link

Lint for foreign tables and materialized view on API search path #60

Open olirice opened 2 months ago

olirice commented 2 months ago

RLS is not supported for foreign tables or materialized views

Ideally they will not be in the search path.

Remediation would be to move them to a private schema and access them through a function (that implements relevant security)