Cannot create policy on a legacy table, even if RLS can be enabled
Hi. I have an issue on a legacy table (created in 2021).
The user postgres owns this table, and can enable RLS on it, but that's it. It cannot create policies, it always gives me this :
ERROR: 42501: permission denied for schema auth. That table is in public schema, not in auth so I don't get why I am having this error. Same error when trying to create the actual policy on dbeaver.
Here is the very basic policy I want to create:
CREATE POLICY tous_select ON public."Liste_appreciations" FOR SELECT USING (true);
Has anyone faced the same issue ?
Thanks.0 Replies