Mercurial > gemma

comparison schema/auth.sql @ 840:0f61bfc21041

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added end point to get style (colour) information for feature.
author Sascha Wilde <wilde@intevation.de>
date Fri, 28 Sep 2018 10:56:03 +0200
parents ea0eb6ef98ce
children 6902032757e4
comparison
equal deleted inserted replaced
839:157a3e42d4af 840:0f61bfc21041
8 REVOKE ALL ON SCHEMA public FROM PUBLIC; 8 REVOKE ALL ON SCHEMA public FROM PUBLIC;
9 9
10 -- 10 --
11 -- Privileges for waterway_user 11 -- Privileges for waterway_user
12 -- 12 --
13 GRANT USAGE ON SCHEMA public, users, waterway TO waterway_user; 13 GRANT USAGE ON SCHEMA public, users, waterway, systemconf TO waterway_user;
14 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user; 14 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user;
15 GRANT SELECT ON systemconf.feature_colours TO waterway_user;
15 GRANT UPDATE (pw, map_extent, email_address) ON users.list_users 16 GRANT UPDATE (pw, map_extent, email_address) ON users.list_users
16 TO waterway_user; 17 TO waterway_user;
17 18
18 -- 19 --
19 -- Extended privileges for waterway_admin 20 -- Extended privileges for waterway_admin