Oracle grant select on schema

BEGIN
   FOR R IN (SELECT owner, table_name FROM all_tables 
             WHERE owner='OTHER_SCHEMA') LOOP
      EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||
                         R.owner || '.' || R.table_name || ' TO MY_SCHEMA';
   END LOOP;
END;

Similar codes

3 votes369 views2 answers
@sqlresultsetmapping
SQL
1 vote330 views1 answer
Increase date by one day in sql oracle
SQL
1 vote366 views1 answer
How to remove identity from a column in sql server
SQL
1 vote373 views1 answer
Connect to mysql database ubuntu
SQL
0 vote360 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
2 votes335 views2 answers
Set database timezone mysql
SQL
0 vote347 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote348 views1 answer
No suitable driver found for sqlite
SQL
6 votes372 views4 answers
Mysql group by date
SQL
0 vote393 views1 answer
Insert query return id mysql
SQL