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

0 vote285 views1 answer
Min salary in sql
SQL
1 vote289 views1 answer
Sql convert month name to number
SQL
0 vote271 views1 answer
Ms sql unique
SQL
4 votes322 views2 answers
Oracle drop job
SQL
0 vote320 views2 answers
List all constraints in postgres
SQL
5 votes289 views1 answer
Oracle sysdate
SQL
28 votes313 views6 answers
Foreign key
SQL
0 vote360 views1 answer
Reindexing all tables sql server
SQL
3 votes345 views3 answers
Update con select postgresql
SQL
0 vote288 views1 answer
Oracle sql winter time change
SQL