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 vote270 views1 answer
Mysql export search results
SQL
10 votes268 views1 answer
Oracle dependencies table
SQL
0 vote259 views1 answer
Select in select sql
SQL
0 vote259 views1 answer
Mysqldump ignore table
SQL
0 vote208 views1 answer
Testing sql queries
SQL
1 vote300 views2 answers
Full join
SQL
0 vote266 views1 answer
Running query in redshift
SQL
0 vote373 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote248 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote267 views1 answer
Alter owner in PostgreSQL
SQL