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

1 vote191 views1 answer
Sql into vs insert into
SQL
3 votes190 views1 answer
Postgres select max value
SQL
0 vote224 views1 answer
Pl sql round
SQL
0 vote207 views1 answer
Sql server synonym
SQL
0 vote130 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote171 views2 answers
Mysql unique two columns
SQL
3 votes190 views1 answer
Oracle revoke
SQL
2 votes173 views1 answer
Oracle sql day of month from date
SQL
0 vote209 views1 answer
Sqlcl format
SQL
0 vote246 views1 answer
Sql filter rows with condition
SQL