Unable to generate types with Supabase CLI due to permission denied for private schema

create or REPLACE FUNCTION private.db_pre_request () returns void language plpgsql stable security definer
set search_path = public as $function$
declare groups jsonb;

begin -- get current groups from auth.users
select raw_app_meta_data->'groups'
from auth.users into groups
where id = auth.uid();

-- store it in the request object
perform set_config(
    'request.groups'::text,
    groups::text,
    false
    /* applies to transaction if true, session if false */
);

end;

$function$;

grant usage on schema private to authenticated,
    postgres;

> dotenv -e .env.local -- pnpm dlx supabase gen types --lang=typescript --project-id "$SUPABASE_PROJECT_ID" --schema public > src/types/database.ts

failed to retrieve generated types: {"message":"{\"code\":\"42501\",\"details\":null,\"hint\":null,\"message\":\"permission denied for schema private\"}"}