Failed to toggle RLS: must be owner of table spatial_ref_sys

[Vedsaga]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

Linter suggesting to apply the RLS on table public.spatial_ref_sys. But, we can't do that, attaching the error
Failed to toggle RLS: must be owner of table spatial_ref_sys

Screenshots

[olirice]

spatial_ref_sys comes from the PostGIS so the best solution here would be to drop and recreate that extension inside a dedicated schema. PostGIS comes with lots of sql entities so i'd recommend making a separate "gis" schema for it

[Vedsaga]

Does that mean Linter only analyze the public schema ?

[olirice]

The linter only confirms that RLS is enabled for tables that are exposed over your APIs. By default, that's the public schema. If you update your API settings to include additional schemas, those would be scanned as well. You can see the implementation of that logic here

splinter/lints/0013_rls_disabled_in_public.sql

Line 38 in 82f1f09

and n.nspname = any(array(select trim(unnest(string_to_array(current_setting('pgrst.db_schemas', 't'), ',')))))