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 vote368 views1 answer
Tsql replace value in json
SQL
0 vote340 views1 answer
Every Derived yable must have its own alias
SQL
0 vote330 views1 answer
Sql create text column limited values
SQL
9 votes364 views3 answers
Find all tables with column name
SQL
0 vote323 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote324 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
4 votes334 views2 answers
Select first and last row mysql
SQL
0 vote335 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote335 views1 answer
Convert rows to columns in sql server
SQL
14 votes344 views1 answer
Oracle alter table add column not null
SQL