Mercurial > gemma
comparison schema/auth.sql @ 840:0f61bfc21041
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 |