begin
    dbms_output.put_line('GRANTS: started...');
    for x in (select 'GRANT SELECT ON '||owner||'.'||table_name||' to USUARIO_RECEBEDOR' sql_stmt
                from all_tables
                where owner='USUARIO_DOADOR' )
    loop
        dbms_output.put_line( x.sql_stmt );
        execute immediate x.sql_stmt;
        dbms_output.put_line( 'success: ' || x.sql_stmt );
    end loop;
    dbms_output.put_line('GRANTS: completed.');
end;

hostgator