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 vote205 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote152 views1 answer
Postgresql subquery
SQL
2 votes202 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
23 votes200 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote280 views1 answer
Install ms sql server management studio
SQL
0 vote244 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
-1 vote195 views3 answers
Error mysql shutdown unexpectedly
SQL
15 votes180 views2 answers
Install mysql 8 ubuntu 18.04
SQL
3 votes190 views2 answers
Oracle sql truncate table
SQL
4 votes206 views1 answer
Sql data types
SQL