Unable to add a policy to auth.users why ?
I can't add this policy to auth.users :
alter table auth.users enable row level security;
create policy "Allow authenticated read" on auth.users for select using (auth.role() = 'authenticated');
He said to me : ERROR: 42501: must be owner of table users
Apparently it's because with the free plan you can't, but does anyone have a solution?
alter table auth.users enable row level security;
create policy "Allow authenticated read" on auth.users for select using (auth.role() = 'authenticated');
He said to me : ERROR: 42501: must be owner of table users
Apparently it's because with the free plan you can't, but does anyone have a solution?