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:[email protected]] On Behalf > Of Simon SPDBA Greener > Sent: Sunday, July 17, 2022 11:26 PM > To: [email protected] > 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) [email protected] > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
