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

6 votes197 views2 answers
Mysql set primary key
SQL
0 vote211 views1 answer
Mysql 8 geo to json
SQL
0 vote240 views1 answer
Sql server synonym
SQL
1 vote206 views1 answer
Return size of tables in mysql
SQL
0 vote231 views1 answer
Sql select lowest value row
SQL
3 votes223 views2 answers
Check data in table mysql
SQL
1 vote185 views1 answer
Launch sql script from docker in mysql
SQL
1 vote186 views1 answer
Oracle lock user
SQL
0 vote189 views1 answer
Distinct data types in a table sql query
SQL
0 vote207 views1 answer
Mysql DDL
SQL