Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#3680 closed defect (fixed)

PostGIS upgrade scripts missing GRANT for views

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 2.2.5
Component: build/upgrade/install Version: 2.2.x
Keywords: Cc:

Description

As noted in https://lists.osgeo.org/pipermail/postgis-users/2016-December/041815.html

using

 ALTER EXTENSION POSTGIS UPDATE TO '2.2.2';

Seems to not set GRANT rights on the geometry_columns, raster_columns, and geography_columns views.

I checked one of the extension update scripts postgis-2.2.3-2.3.1.sql and it has CREATE OR REPLACE VIEW .. but missing these lines that are in the full extension script.

-- make views and spatial_ref_sys public viewable --
GRANT SELECT ON TABLE geography_columns TO public;
GRANT SELECT ON TABLE geometry_columns TO public;
GRANT SELECT ON TABLE spatial_ref_sys TO public;

So I suspect it's been like that for a while.

Change History (6)

comment:1 by robe, 5 years ago

Owner: changed from pramsey to robe

comment:2 by robe, 5 years ago

Component: postgisbuild/upgrade/install

comment:3 by robe, 5 years ago

In 15276:

PostGIS upgrade scripts missing GRANT for views
references #3680 for trunk (PostGIS 2.4)

comment:4 by robe, 5 years ago

In 15278:

PostGIS upgrade scripts missing GRANT for views
references #3680 for PostGIS 2.3

comment:5 by robe, 5 years ago

Resolution: fixed
Status: newclosed

In 15279:

PostGIS upgrade scripts missing GRANT for views
closes #3680 for PostGIS 2.2
also correct strk's email

comment:6 by robe, 5 years ago

In 15286:

KNN recheck in 9.5+ fails with index returned tuples in wrong order
closes #3418 for PostGIS 2.2
add NEWS note for missing GRANT in upgrade
references #3680

Note: See TracTickets for help on using tickets.