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 vote231 views1 answer
Set mysql socket file docker windows
SQL
0 vote215 views1 answer
Sql field equals multiple values
SQL
2 votes239 views5 answers
Install postgresql 10 centos 7
SQL
0 vote175 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote222 views1 answer
Postgresql concat string with separator
SQL
0 vote190 views1 answer
Mariadb errno 121
SQL
0 vote260 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote190 views1 answer
Subquery aggregation
SQL
7 votes181 views3 answers
How ot change name of column mysql
SQL
0 vote210 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL