Storage upload fails with 42P01 for custom JWT roles

Hi, I'm having an issue where users with custom JWT roles (administrator and moderator) cannot upload files to storage and get:

upload failed — database error, code: 42P01

Regular authenticated users upload fine. Setup: I have a custom access token hook that replaces the role claim in the JWT with a custom role from my server.staff_members table:

if found then
  v_new_claims := jsonb_set(v_new_claims, '{role}', to_jsonb(v_staff_role::text));
end if;

So for staff users, role in JWT becomes administrator or moderator instead of authenticated.

Custom roles:

do $$
begin
  if not exists (select 1 from pg_roles where rolname = 'administrator') then
    create role administrator noinherit nologin;
  end if;

  if not exists (select 1 from pg_roles where rolname = 'moderator') then
    create role moderator noinherit nologin;
  end if;
end
$$;

grant administrator to authenticator;
grant moderator to authenticator;

grant usage on schema management to administrator, moderator;

Storage policy (with check): Editing policy from storage.objects Docs Policy name A descriptive name for your policy