Thanks
Simon
On 19/07/2022 3:01 am, Regina Obe wrote:
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
--
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
