view schema/updates/1424/01.add_axis_rls.sql @ 5560:f2204f91d286

Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents 7dff1015283d
children
line wrap: on
line source

CREATE POLICY hide_nothing ON waterway.waterway_axis
    FOR SELECT TO waterway_user USING (true);
CREATE POLICY sys_admin ON waterway.waterway_axis
    FOR ALL TO sys_admin USING (true);

CREATE POLICY responsibility_area_insert ON waterway.waterway_axis
    FOR INSERT TO waterway_admin
    WITH CHECK (users.utm_covers(wtwaxs));
CREATE POLICY responsibility_area_update ON waterway.waterway_axis
    FOR UPDATE TO waterway_admin
    USING (users.utm_covers(wtwaxs));
CREATE POLICY responsibility_area_delete ON waterway.waterway_axis
    FOR DELETE TO waterway_admin
    USING (users.utm_covers(wtwaxs));

ALTER TABLE waterway.waterway_axis ENABLE ROW LEVEL SECURITY;