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 :
Here is the very basic policy I want to create:
Has anyone faced the same issue ?
Thanks.
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 authpublicauthHere 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.
