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

5 votes211 views2 answers
Add column postgres with default value
SQL
0 vote224 views1 answer
Alter check command
SQL
2 votes192 views2 answers
Sqlite_busy: database is locked
SQL
20 votes207 views5 answers
Reset auto increment mysql
SQL
3 votes226 views1 answer
Postgres select max value
SQL
0 vote214 views1 answer
Sql common columns
SQL
0 vote218 views1 answer
Check for directory in bash
SQL
0 vote204 views1 answer
How to use lower case in mysql
SQL
2 votes241 views1 answer
Select a certain number of entries from select mysql
SQL
2 votes209 views1 answer
Oracle find unusable indexes
SQL