[Solved] PostGIS needs read acces to some spatial tables

[wambachr]

Hi,

 

select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460.3998016127,6469630.074057321,3857),4326));

 

does not work (yet):

ERROR:  permission denied for relation spatial_ref_sys
CONTEXT:  SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid = 3857 LIMIT 1"
 

this PostGIS tables/views will need r/o access:

 

spatial_ref_sys

geography_column

geometry_columns

 

Regard

walter

 

host: Tommy

db: wambachr_osm

db user: wambachr_postgres & wambachr_osmuser

Edited November 26, 2020 by wambachr

[OnEnemy]

This support request is being escalated to our root admins.

[Krydos]

Does it work now?

[wambachr]

Bingo

select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460.
           3998016127,6469630.074057321,3857),4326));

                                                                            st_astext                                                                             
------------------------------------------------------------------------------------------------------------------------------------------------------------------
 POLYGON((8.1298828125 50.1205780979601,8.1298828125 50.134664322167,8.15185546875 50.134664322167,8.15185546875 50.1205780979601,8.1298828125 50.1205780979601))
(1 row)

Yes, that problem is gone.

 

regards

walter, may be the only user on tommy doing this stuff