[postgis-users] topology permissions

[Regina Obe]

Looks like you are missing the USAGE rights for the schema.
I think Sandro fixed this in upcoming micro releases, which I hope to push out this week.

- #5124, GRANT USAGE on topology schema to PUBLIC (Sandro Santilli)
https://trac.osgeo.org/postgis/ticket/5124


GRANT USAGE ON SCHEMA topology TO PUBLIC


> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
> Of Simon SPDBA Greener
> Sent: Sunday, July 17, 2022 11:26 PM
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] topology permissions
> 
> I have inherited a database in which PostGIS Topology is installed.
> 
> When I execute:
> 
> SELECT topology.CreateTopology('df_topo', 28356, 0.1);
> 
> I get:
> 
> ERROR:  permission denied for schema topology LINE 1: SELECT
> topology.CreateTopology('df_topo', 28356, 0.1);                 ^ SQL state: 42501
> Character: 8
> 
> Can someone inform me what permissions my user needs to be able to
> execute topology functions.
> 
> regards
> 
> Simon--
> 
> Simon Greener
> 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
> (m) +61 418 396 391
> (w) www.spdba.com.au
> (m) simon at spdba.com.auI
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users