Mercurial > gemma

comparison schema/auth.sql @ 1168:930fdd8b474f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Track successfull imports in a separate table to be able to remove them later.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 14 Nov 2018 12:23:10 +0100
parents da0a62fcfd80
children d395b2940a82
comparison
equal deleted inserted replaced
1167:1ae93a0438df 1168:930fdd8b474f
22 GRANT INSERT, UPDATE ON ALL TABLES IN SCHEMA waterway TO waterway_admin; 22 GRANT INSERT, UPDATE ON ALL TABLES IN SCHEMA waterway TO waterway_admin;
23 -- TODO: will there ever be UPDATEs or can we drop that due to historicisation? 23 -- TODO: will there ever be UPDATEs or can we drop that due to historicisation?
24 GRANT INSERT, UPDATE, DELETE ON 24 GRANT INSERT, UPDATE, DELETE ON
25 users.templates, users.user_templates TO waterway_admin; 25 users.templates, users.user_templates TO waterway_admin;
26 GRANT INSERT, UPDATE, DELETE ON 26 GRANT INSERT, UPDATE, DELETE ON
27 waterway.imports, waterway.import_logs TO waterway_admin; 27 waterway.imports, waterway.import_logs, waterway.track_imports TO waterway_admin;
28 28
29 -- 29 --
30 -- Extended privileges for sys_admin 30 -- Extended privileges for sys_admin
31 -- 31 --
32 GRANT INSERT, UPDATE, DELETE 32 GRANT INSERT, UPDATE, DELETE