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

1 vote177 views1 answer
Count mysql server db tables
SQL
0 vote176 views1 answer
Get schema of table sql
SQL
4 votes187 views2 answers
Tables in sql
SQL
1 vote173 views1 answer
Select count distinct multiple columns sql server
SQL
21 votes138 views7 answers
Table drop if exist sql server
SQL
3 votes157 views1 answer
Oracle revoke grant
SQL
4 votes247 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote181 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote171 views1 answer
Mysql backup certain tables workbench
SQL
3 votes181 views4 answers
Truncate syntax in sql
SQL