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 vote292 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
42 votes247 views6 answers
Sql query duplicate rows
SQL
0 vote174 views1 answer
Delete insert record in sql server
SQL
0 vote193 views1 answer
SQL Server date literal
SQL
1 vote183 views2 answers
Sql insert timestamp
SQL
0 vote319 views1 answer
How to find the most occuring in SQL
SQL
0 vote180 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote179 views1 answer
Modifier une valeur sql
SQL
0 vote336 views1 answer
Current month transactions in mysql
SQL
3 votes161 views1 answer
Search for column name in psql
SQL