[postgis-users] topology permissions

[Simon SPDBA Greener]

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: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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> 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) simon at spdba.com.au