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 vote203 views1 answer
Too many connections mysql
SQL
1 vote208 views1 answer
How to open closed port mysql in ubuntu
SQL
9 votes202 views3 answers
Oracle undo usage by session
SQL
1 vote282 views3 answers
Showing all columns in an sqlite table
SQL
1 vote196 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote184 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote203 views2 answers
Close external port 3306 with iptables
SQL
0 vote233 views3 answers
Convert sql query to python pandas
SQL
0 vote191 views1 answer
Create a view in sqlite
SQL
2 votes217 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL