[Solved] remote access and postgis postgresql

[darkdest]

I want to remote access and enabled postgis extension on my postgresql database

My database is

 

db_username : hiruma_hito

db_name : hiruma_monitor

db_server : ricky

 

Thank you

 

[Flaze]

This support request is being escalated to our root admin.

[Krydos]

Remote access enabled and postgis extension created.

[darkdest]

Remote access enabled and postgis extension created.

Thank You Krydos

[darkdest]

can you ran command :

 

ALTER TABLE spatial_ref_sys OWNER TO hiruma_hito

 

or this command :

 

GRANT ALL ON TABLE spatial_ref_sys TO hiruma_monitor

 

I need a query that use spatial_ref_sys table to do, so everytime the query executed, it will fail

Edited August 17, 2019 by darkdest

[darkdest]

I am sorry, that command can be done by clicking synchronize grants, and now the query can be executed

sorry for distrubtion