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 vote213 views3 answers
Query string not ending with with vowels
SQL
-1 vote215 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote212 views1 answer
Get last date join sql
SQL
2 votes188 views3 answers
How to get second highest salary in each department in sql
SQL
1 vote199 views2 answers
Oracle list partitioned tables
SQL
0 vote210 views1 answer
Mysql docker image arjun
SQL
3 votes215 views1 answer
Stpop start psql server
SQL
1 vote207 views2 answers
How to check if sql query is correct online
SQL
0 vote196 views2 answers
Mysql slave status
SQL
2 votes235 views3 answers
Row number mysql
SQL