Doadmin permissions for spatial_ref_sys in postgis
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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×