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;