Grant select on all tables belonging to another user

SELECT 'GRANT SELECT ON '||owner||'.'|| table_name ||' TO your_user;' FROM all_tables WHERE owner = 'your_owner';