X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/021702f1906bc7e4001913020c510f7ba2a80998..c51ca976eda5a0aea1e3649728dc511ed372978e:/sql/tables.sql diff --git a/sql/tables.sql b/sql/tables.sql index b27f8e32..9126c629 100644 --- 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;