Mercurial > gemma
comparison schema/auth.sql @ 1168:930fdd8b474f
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 |