linz / gazetteer

New Zealand Gazetteer of official place names
http://www.linz.govt.nz/regulatory/place-names/find-name/new-zealand-gazetteer-official-geographic-names/new-zealand-gazetteer-search-place-names#zoom=0&lat=-41.14127&lon=172.5&layers=BTTT
Other
2 stars 2 forks source link

docker gazadmin user does not have admin privileges #136

Closed SPlanzer closed 4 years ago

SPlanzer commented 4 years ago

test user gazadim is as below

CREATE ROLE gazadmin LOGIN
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
GRANT gazetteer_admin TO gazadmin;

However when using this user for test admion functionlitry reports You are not authorised to run gazetteer administration functions

SPlanzer commented 4 years ago

this is evaluated via gazetteer.gaz_IsGazetteerDba()

SPlanzer commented 4 years ago

below fixes the issue

postgres=# GRANT gazetteer_dba TO gazadmin; postgres=# GRANT gazetteer_user TO gazadmin;