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 vote271 views1 answer
Update and replace mysql
SQL
2 votes282 views1 answer
Power query concatenate
SQL
0 vote276 views1 answer
Vowels in sql
SQL
0 vote368 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote304 views2 answers
How to truncate all table in mysql workbench
SQL
17 votes264 views5 answers
Order by sql
SQL
10 votes295 views2 answers
Mysql alter add foreign key
SQL
-1 vote299 views4 answers
Sql view postgresql
SQL
0 vote276 views1 answer
Where date in datetime mysql
SQL
0 vote294 views1 answer
Vs 2019 connect to local mysql database
SQL