RLS Update Own Profile - Denied

I am following the Public Access example in the docs to allow "User can update own profile" (https://supabase.com/docs/guides/auth/managing-user-data)

I am getting access denied for the policy:

create policy "Users can update own profile."
  on profiles for update
  using ( auth.uid() = id );

create policy "Users can update own profile."
  on profiles for update
  using ( auth.uid() = id );

using this update statement with the supabase js client:

const { data, error } = await supabase
  .from('profiles')
  .update({
    ...formValues,
  })
  .match({ id: user?.id });

const { data, error } = await supabase
  .from('profiles')
  .update({
    ...formValues,
  })
  .match({ id: user?.id });

any idea why? This is on a nextjs page where the user is authenticated

Supabase•4y ago•

42 replies

I am following the Public Access example in the docs to allow "User can update own profile" (https://supabase.com/docs/guides/auth/managing-user-data)

I am getting access denied for the policy:

create policy "Users can update own profile."
  on profiles for update
  using ( auth.uid() = id );

create policy "Users can update own profile."
  on profiles for update
  using ( auth.uid() = id );

using this update statement with the supabase js client:

const { data, error } = await supabase
  .from('profiles')
  .update({
    ...formValues,
  })
  .match({ id: user?.id });

const { data, error } = await supabase
  .from('profiles')
  .update({
    ...formValues,
  })
  .match({ id: user?.id });

any idea why? This is on a nextjs page where the user is authenticated