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 vote320 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
2 votes408 views3 answers
Mysql unix timestamp to date
SQL
4 votes332 views3 answers
Mysql modify foreign key
SQL
0 vote337 views1 answer
Sql server datetime
SQL
12 votes327 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote345 views2 answers
Alter table add multiple columns mysql
SQL
1 vote338 views1 answer
Postgres convert date to string
SQL
0 vote336 views1 answer
Oracle allow space to user
SQL
0 vote365 views1 answer
Insert into table with only identity column
SQL
22 votes376 views4 answers
Date format mysql
SQL