Starting with Oracle Database 23ai, this becomes easy:
grant select any table on schema OwningUser to ReceivingUser