PostGIS upgrade scripts missing GRANT for views

[robe]

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.

[robe]

In 15276:

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

[robe]

In 15278:

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

[robe]

In 15279:

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

[robe]

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