jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER = ON)(LOAD_BALANCE = OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cluprod-scan.entreprise.tpf.ch)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=clustb-scan.entreprise.tpf.ch)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME = CARL)))

FOR x IN (SELECT * FROM user_tables)

LOOP

 EXECUTE IMMEDIATE 'GRANT SELECT ON ' || x.table_name || ' TO <<someone>>';

END LOOP;