[postgis-devel] Lower Priv Users and PostGIS

Paragon Corporation lr at pcorp.us
Wed Nov 28 17:32:59 PST 2012

I already have this ticketed BTW


-----Original Message-----
From: postgis-devel-bounces at lists.osgeo.org
[mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Sandro Santilli
Sent: Wednesday, November 28, 2012 12:23 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] Lower Priv Users and PostGIS

On Wed, Nov 28, 2012 at 11:17:43AM -0600, Paul Ramsey wrote:

> weak=# create extension postgis;
> weak=# \q
> # psql -U weak weak
> weak=> select * from geometry_columns ;
> ERROR:  permission denied for relation geometry_columns weak=> \q
> Do we want this to be the default, or do we want low-priv users to be 
> able to use PostGIS after install?

I'm sure this issue came out at least another time.
Andrea Peri requested to put some grants into the enabler script.

I don't have a strong opinion on the matter but I'm afraid that stepping
into the database administrator role could open a can of worms.
Maybe she wants to define a group of people with usage privs...

Note that for topology you can't even run the functions if you're note
explicitly granted usage on the "topology" schema.


postgis-devel mailing list
postgis-devel at lists.osgeo.org

More information about the postgis-devel mailing list