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 vote336 views1 answer
Psql no such file or directory
SQL
0 vote362 views1 answer
Create new schema mysql
SQL
0 vote348 views1 answer
Mysql regex exact match
SQL
3 votes363 views2 answers
Current year sql
SQL
9 votes334 views2 answers
Get first 3 letters in sql
SQL
0 vote307 views2 answers
Delete the last item in a table sql
SQL
0 vote338 views1 answer
Xampp mysql version
SQL
1 vote357 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote348 views2 answers
Select only columns that are not empty oracle sql
SQL
1 vote320 views1 answer
Reutrn string after character sql
SQL