SQL> connect scott/tiger
Connected.

  1* select 'GRANT SELECT ON ' || table_name || ' TO HR;' from user_tables
SQL> /

'GRANTSELECTON'||TABLE_NAME||'TOHR;'
-----------------------------------------------------
GRANT SELECT ON DEPT TO HR;
GRANT SELECT ON EMP TO HR;
GRANT SELECT ON BONUS TO HR;
GRANT SELECT ON SALGRADE TO HR;
GRANT SELECT ON STAT_TABLE TO HR;
GRANT SELECT ON EMPLOYEES_LOG TO HR;
GRANT SELECT ON DATA_STAGING_REPOS TO HR;

7 rows selected.

SQL>