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 vote132 views1 answer
Window functions in sql
SQL
0 vote163 views1 answer
Tsql cte in a transaction
SQL
6 votes118 views4 answers
Mysql update set
SQL
1 vote171 views1 answer
Connect to mysql database ubuntu
SQL
1 vote135 views2 answers
Begin transaction in sql
SQL
4 votes143 views1 answer
Sql quote in string
SQL
2 votes135 views5 answers
SQL trigger
SQL
8 votes131 views1 answer
Oracle search source code
SQL
0 vote139 views1 answer
Psql show db
SQL
8 votes131 views1 answer
Oracle add auto_increment column to existing table
SQL