Mercurial > gemma

comparison schema/auth.sql @ 3649:fb8a53c7c6d3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 --