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 vote374 views2 answers
Laravel jwt generate token
SQL
9 votes314 views6 answers
Sql add column with default value
SQL
31 votes332 views4 answers
Mysql grant execute
SQL
0 vote324 views1 answer
Mysql 1 hour ago
SQL
0 vote298 views1 answer
How to fetch highest score in minimum time using mysql
SQL
1 vote328 views1 answer
Mysql add fields
SQL
0 vote306 views3 answers
Drop multiple columns in sql
SQL
0 vote355 views1 answer
Combine 2 columns search query mysql
SQL
12 votes306 views1 answer
Env var for setting password for root user mysql docker hub
SQL
1 vote306 views1 answer
Return size of tables in mysql
SQL