switch remaining GRANTs to configurable web user

fixes #252

diff --git a/data/country_name.sql b/data/country_name.sql
index eb52cc5da2764116c97bb8d228619165e3688e3e..352337a7ba9121753477a59928c58b7ef91ab83c 100644 (file)
--- a/data/country_name.sql
+++ b/data/country_name.sql
@@ -295,7 +295,6 @@ CREATE INDEX idx_country_name_country_code ON country_name USING btree (country_
 --
 
 REVOKE ALL ON TABLE country_name FROM PUBLIC;
-GRANT SELECT ON TABLE country_name TO "www-data";
 
 
 --

diff --git a/data/gb_postcode_table.sql b/data/gb_postcode_table.sql
index 7cd3f6940ab004a96139efeb59098f5376886fc3..bee8a964f191003ae6e7117a9302b239186ad47c 100644 (file)
--- a/data/gb_postcode_table.sql
+++ b/data/gb_postcode_table.sql
@@ -24,4 +24,3 @@ CREATE TABLE gb_postcode (
     CONSTRAINT enforce_srid_geometry CHECK ((st_srid(geometry) = 4326))
 );
 
-GRANT SELECT ON TABLE gb_postcode TO "www-data";

diff --git a/sql/tables.sql b/sql/tables.sql
index b27f8e321fa1f52e9c7116ee0d67903bba0b846d..9126c6299e35b1e50986ff137ba350bc073828fe 100644 (file)
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -53,6 +53,9 @@ GRANT INSERT ON new_query_log TO "{www-user}" ;
 GRANT UPDATE ON new_query_log TO "{www-user}" ;
 GRANT SELECT ON new_query_log TO "{www-user}" ;
 
+GRANT SELECT ON TABLE country_name TO "{www-user}";
+GRANT SELECT ON TABLE gb_postcode TO "{www-user}";
+
 create view vw_search_query_log as SELECT substr(query, 1, 50) AS query, starttime, endtime - starttime AS duration, substr(useragent, 1, 20) as 
 useragent, language, results, ipaddress FROM new_query_log WHERE type = 'search' ORDER BY starttime DESC;
 

diff --git a/utils/specialphrases.php b/utils/specialphrases.php
index 13480695d5b806b69c6c9861b58e3991e208f20d..97b60dde39e974f15d24159061aadac2072bb1c9 100755 (executable)
--- a/utils/specialphrases.php
+++ b/utils/specialphrases.php
@@ -105,7 +105,7 @@
                                echo " tablespace ".CONST_Tablespace_Aux_Index;
                        echo ";\n";
 
-            echo "GRANT SELECT ON place_classtype_".pg_escape_string($aPair[0])."_".pg_escape_string($aPair[1])." TO \"www-data\";\n";
+            echo "GRANT SELECT ON place_classtype_".pg_escape_string($aPair[0])."_".pg_escape_string($aPair[1]).' TO "'.CONST_Database_Web_User."\";\n";
 
                }