Hi, I am trying to create a spatial table by using

ogr2ogr

from my laptop (basically, I am trying to import a MapInfo TAB into the DB which PostGIS activated) but getting the error below

ERROR 1: ERROR:  permission denied for table spatial_ref_sys

I think it is because the

spatial_ref_sys

table is owned by

supabase_admin

user and my default db user does not have write access to that table. How can I fix this? Thanks

Try doing

ALTER TABLE spatial_ref_sys OWNER TO <your_user>

on the Supabase SQL Editor.

Hi - I tried that but is not an administrator and not the owner of the table, hence the ALTER command fails

I see. I'd suggest opening an issue then https://github.com/supabase/supabase/issues

Thanks! I posted this to Q&A forum but no luck so far (could be the wording :/ ) https://github.com/supabase/supabase/discussions/7661