Mercurial > gemma

comparison schema/auth.sql @ 179:382f631d8dd8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add missing privilege for waterway_admin
author Tom Gottfried <tom@intevation.de>
date Tue, 17 Jul 2018 18:21:56 +0200
parents 4e2451d561b1
children 0423eab4ad45
comparison
equal deleted inserted replaced
178:2111ad473961 179:382f631d8dd8
20 -- Extended privileges for waterway_admin 20 -- Extended privileges for waterway_admin
21 -- 21 --
22 GRANT INSERT, UPDATE ON ALL TABLES IN SCHEMA gemma_waterway, gemma_fairway 22 GRANT INSERT, UPDATE ON ALL TABLES IN SCHEMA gemma_waterway, gemma_fairway
23 TO waterway_admin; 23 TO waterway_admin;
24 -- TODO: will there ever be UPDATEs or can we drop that due to historicisation? 24 -- TODO: will there ever be UPDATEs or can we drop that due to historicisation?
25 GRANT INSERT, UPDATE ON templates, user_templates TO waterway_admin; 25 GRANT INSERT, UPDATE, DELETE ON templates, user_templates TO waterway_admin;
26 GRANT SELECT ON responsibility_areas TO waterway_admin; 26 GRANT SELECT ON responsibility_areas TO waterway_admin;
27 27
28 -- 28 --
29 -- Extended privileges for sys_admin 29 -- Extended privileges for sys_admin
30 -- 30 --