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 vote139 views1 answer
Sql server separar numeros por comas miles
SQL
3 votes265 views6 answers
Sql unique select
SQL
1 vote135 views10 answers
Stack overflow
SQL
7 votes161 views3 answers
Sql server check if temp table exists
SQL
0 vote143 views1 answer
How to open mysql in docker
SQL
4 votes141 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote125 views1 answer
Update set with inner join oracle
SQL
18 votes134 views6 answers
Drop table if exists
SQL
12 votes138 views1 answer
Script to add new column in table sql
SQL
1 vote98 views1 answer
Unique vs distinct sql
SQL