Mercurial > gemma

comparison schema/auth.sql @ 2079:9318973487a1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Waterway profiles import: Implemented the parsing of the data lines of the CSV file and stored the values into the database.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 30 Jan 2019 23:57:51 +0100
parents 59055c8301df
children b66cfcde8ff7
comparison
equal deleted inserted replaced
2078:dacf79a0658e 2079:9318973487a1
121 -- TODO: add all relevant tables here 121 -- TODO: add all relevant tables here
122 122
123 CREATE POLICY same_country ON waterway.gauge_measurements 123 CREATE POLICY same_country ON waterway.gauge_measurements
124 FOR ALL TO waterway_admin 124 FOR ALL TO waterway_admin
125 USING ((fk_gauge_id).country_code = users.current_user_country()); 125 USING ((fk_gauge_id).country_code = users.current_user_country());
126
127 CREATE POLICY same_country ON waterway.waterway_profiles
128 FOR ALL TO waterway_admin
129 USING ((location).country_code = users.current_user_country());
126 130
127 CREATE POLICY responsibility_area ON waterway.bottlenecks 131 CREATE POLICY responsibility_area ON waterway.bottlenecks
128 FOR ALL TO waterway_admin 132 FOR ALL TO waterway_admin
129 USING (utm_covers(area)); 133 USING (utm_covers(area));
130 134