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 vote226 views1 answer
ORA-00942
SQL
1 vote144 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote185 views2 answers
Cascade syntax in sql
SQL
0 vote140 views1 answer
Function sum(text) does not exist postgres
SQL
2 votes125 views1 answer
Can you use a where clause for a child query
SQL
1 vote153 views5 answers
Sql 2nd highest salary
SQL
0 vote143 views1 answer
Generate sequence number in sql server
SQL
0 vote159 views1 answer
The fetch keyword oracle
SQL
0 vote132 views2 answers
Android sqlite tutorial for beginners
SQL
31 votes143 views3 answers
SQL Server change column data type
SQL