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

8 votes325 views1 answer
Mysql limit rows
SQL
3 votes289 views2 answers
Mysql create timestamp column
SQL
1 vote278 views1 answer
Loading local data is disabled mysql
SQL
0 vote299 views1 answer
Sql date between one week
SQL
0 vote282 views2 answers
Sql use not in
SQL
0 vote275 views1 answer
Not between mysql
SQL
1 vote282 views1 answer
Mysql remove last empty newline
SQL
1 vote278 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
3 votes284 views2 answers
Plsql print
SQL
3 votes277 views1 answer
Postgres update column with value from another table
SQL