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 vote150 views1 answer
Sql count * vs count 1
SQL
20 votes145 views2 answers
Counting in sql
SQL
0 vote158 views1 answer
Oracle sql add column auto generated value
SQL
0 vote167 views2 answers
Mysql insert into multiple tables
SQL
17 votes169 views3 answers
Postgresql list users
SQL
17 votes278 views4 answers
Show all tables in oracle
SQL
0 vote149 views1 answer
Sql server change schema of a table
SQL
0 vote151 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote175 views1 answer
Mysqldump: error:
SQL
0 vote149 views1 answer
Mysql select where field like in list
SQL