Doadmin permissions for spatial_ref_sys in postgis

November 29, 2019 72 views
DigitalOcean Managed PostgreSQL Database

I’ve created a Managed PostgreSQL Database with the Postgis extension. It creates the spatialrefsys table with the list of supported reference projections for spatial queries. I need to add a new projection to spatialrefsys but it gives the error: permission denied for table spatialrefsys. I’ve used the doadmin user to create the extension and the table spatialrefsys is owned by postgres user. I can’t change the ownership, neither the permissions. How can I do that with my user privileges?


Be the first one to answer this question.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!