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 vote304 views1 answer
Mysql read row
SQL
18 votes298 views3 answers
Mysql number format
SQL
0 vote299 views1 answer
Compression of dabatase mysqldumo
SQL
3 votes309 views3 answers
Sql last week
SQL
0 vote321 views2 answers
Functions with parameters SQL
SQL
2 votes378 views2 answers
Python escape string for sql
SQL
0 vote304 views2 answers
How to get json data mysql
SQL
1 vote307 views1 answer
Spring postgresql reset auto increment to 0
SQL
1 vote314 views3 answers
Connection string mysql
SQL
1 vote290 views1 answer
Oracle start job
SQL