view schema/updates/1304/01.add_section_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 5b9ba358a4e7
children
line wrap: on
line source

CREATE POLICY hide_staging ON waterway.sections
    FOR SELECT TO waterway_user USING (staging_done);

CREATE POLICY sys_admin ON waterway.sections
    FOR ALL TO sys_admin USING (true);

CREATE POLICY responsibility_area ON waterway.sections
    FOR ALL TO waterway_admin
    USING (users.utm_covers(area));

ALTER TABLE waterway.sections ENABLE ROW LEVEL SECURITY