[postgis-tickets] [SCM] PostGIS branch main updated. 3.2.0alpha1-12-g3ff851a

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, main has been updated
       via  3ff851abfa515b9841007c12a70b83170ccd0305 (commit)
      from  5b8bb33de39731c93b61e8de5e8a78865b1bcb14 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 3ff851abfa515b9841007c12a70b83170ccd0305
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Aug 11 16:53:46 2021 +0200

    GRANT select on topology.topology and topology.layer to PUBLIC
    
    Closes #4575

diff --git a/NEWS b/NEWS
index 777dc85..1fc1d38 100644
--- a/NEWS
+++ b/NEWS
@@ -12,6 +12,7 @@ PostGIS 3.2.0
 
  * Enhancements *
   - #4997, FlatGeobuf format input/output (Björn Harrtell)
+  - #4575, GRANT SELECT on topology metadata tables to PUBLIC (Sandro Santilli)
   - #2592, Do not allow CreateTopology to define topologies with SRID < 0
            (Sandro Santilli)
   - #3232, Prevent moving an isolated node to different face
diff --git a/topology/topology.sql.in b/topology/topology.sql.in
index b1c7463..4956a88 100644
--- a/topology/topology.sql.in
+++ b/topology/topology.sql.in
@@ -1827,4 +1827,9 @@ CREATE OR REPLACE FUNCTION topology.postgis_topology_scripts_installed() RETURNS
 -- Make sure topology is in database search path --
 SELECT topology.AddToSearchPath('topology');
 
+-- Make metadata tables publically visible
+-- See https://trac.osgeo.org/postgis/ticket/4575
+GRANT SELECT ON topology.topology TO PUBLIC;
+GRANT SELECT ON topology.layer TO PUBLIC;
+
 COMMIT;

-----------------------------------------------------------------------

Summary of changes:
 NEWS                     | 1 +
 topology/topology.sql.in | 5 +++++
 2 files changed, 6 insertions(+)


hooks/post-receive
-- 
PostGIS