Mercurial > gemma
comparison schema/auth.sql @ 3649:fb8a53c7c6d3
merged configuration branch into default
author | Markus Kottlaender <markus@intevation.de> |
---|---|
date | Thu, 13 Jun 2019 11:20:17 +0200 |
parents | 9709081719ae |
children | db87f34805fb |
comparison
equal
deleted
inserted
replaced
3648:0ec5c8ec1e44 | 3649:fb8a53c7c6d3 |
---|---|
23 REVOKE ALL ON SCHEMA public FROM PUBLIC; | 23 REVOKE ALL ON SCHEMA public FROM PUBLIC; |
24 | 24 |
25 -- | 25 -- |
26 -- Privileges for waterway_user | 26 -- Privileges for waterway_user |
27 -- | 27 -- |
28 GRANT USAGE ON SCHEMA public, users, waterway, systemconf, caching TO waterway_user; | 28 GRANT USAGE ON SCHEMA public, users, waterway, systemconf, sys_admin, caching TO waterway_user; |
29 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user; | 29 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user; |
30 GRANT SELECT, UPDATE, DELETE, INSERT ON ALL TABLES IN SCHEMA caching TO waterway_user; | 30 GRANT SELECT, UPDATE, DELETE, INSERT ON ALL TABLES IN SCHEMA caching TO waterway_user; |
31 GRANT SELECT ON systemconf.feature_colours TO waterway_user; | 31 GRANT SELECT ON systemconf.feature_colours TO waterway_user; |
32 GRANT SELECT ON sys_admin.system_config TO waterway_user; | |
32 GRANT UPDATE (pw, map_extent, email_address) ON users.list_users | 33 GRANT UPDATE (pw, map_extent, email_address) ON users.list_users |
33 TO waterway_user; | 34 TO waterway_user; |
34 | 35 |
35 -- | 36 -- |
36 -- Extended privileges for waterway_admin | 37 -- Extended privileges for waterway_admin |
63 -- | 64 -- |
64 GRANT INSERT, UPDATE, DELETE | 65 GRANT INSERT, UPDATE, DELETE |
65 ON users.list_users, users.responsibility_areas TO sys_admin; | 66 ON users.list_users, users.responsibility_areas TO sys_admin; |
66 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; | 67 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; |
67 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; | 68 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; |
68 GRANT UPDATE ON sys_admin.system_config TO sys_admin; | 69 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin; |
69 GRANT UPDATE ON systemconf.feature_colours TO sys_admin; | 70 GRANT UPDATE ON systemconf.feature_colours TO sys_admin; |
70 GRANT UPDATE ON sys_admin.published_services TO sys_admin; | 71 GRANT UPDATE ON sys_admin.published_services TO sys_admin; |
71 GRANT INSERT, DELETE ON sys_admin.password_reset_requests TO sys_admin; | 72 GRANT INSERT, DELETE ON sys_admin.password_reset_requests TO sys_admin; |
72 | 73 |
73 -- | 74 -- |