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 vote254 views1 answer
Drop constraint in ms sql
SQL
9 votes240 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote315 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote254 views1 answer
How get data from database if id not found then search another column
SQL
5 votes257 views1 answer
AND OR NOT operators sql
SQL
0 vote255 views1 answer
Sql server on mac m1
SQL
0 vote234 views1 answer
Check index sql server
SQL
0 vote256 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote272 views1 answer
How to get nth number in sql
SQL
0 vote272 views2 answers
Faster mysql imports
SQL