PostGIS upgrade scripts missing GRANT for views
|Reported by:||robe||Owned by:||robe|
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.