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 vote116 views1 answer
Sql view index
SQL
3 votes145 views1 answer
Oracle function return
SQL
0 vote134 views1 answer
Mysql local password denied
SQL
0 vote129 views1 answer
Data types mysql vs postgresql
SQL
4 votes163 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote124 views1 answer
Grant privileges of databse to user
SQL
0 vote127 views1 answer
C# get sql min date
SQL
1 vote106 views1 answer
Tsql update datetime
SQL
0 vote137 views1 answer
Check for directory in bash
SQL
0 vote117 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL