commit ceeaa524f0dd0e9cc5859092c2c371003f390da2 parent cc79e3456129ddb9f5284c90caf31f51c93fc607 Author: Andreas Gruhler <andreas.gruhler@adfinis.com> Date: Wed, 5 Apr 2023 00:19:46 +0200 feat(athletes): delete policy for authenticated users Diffstat:
M | schema/athletes.sql | | | 7 | +++++++ |
1 file changed, 7 insertions(+), 0 deletions(-)
diff --git a/schema/athletes.sql b/schema/athletes.sql @@ -67,6 +67,13 @@ ALTER TABLE ONLY public.athletes -- +-- Name: athletes Enable delete for authenticated users only; Type: POLICY; Schema: public; Owner: postgres +-- + +CREATE POLICY "Enable delete for authenticated users only" ON public.athletes FOR DELETE TO authenticated USING (true); + + +-- -- Name: athletes Enable read access for all users; Type: POLICY; Schema: public; Owner: postgres --