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 vote187 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
2 votes194 views1 answer
Oracle index size
SQL
0 vote182 views1 answer
T-sql update table variale
SQL
0 vote187 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote187 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote199 views1 answer
Mysql change timestamp on update
SQL
-1 vote192 views2 answers
Mysql get day of week
SQL
1 vote187 views4 answers
Fatal database postgres does not exist
SQL
0 vote187 views2 answers
Plan d'exécution requete oracle autotracer
SQL
5 votes176 views1 answer
Oracle scan source ddl
SQL