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 vote220 views1 answer
How to truncate a table in databse
SQL
0 vote223 views1 answer
Mysql repair a table
SQL
1 vote254 views1 answer
Sqlalchemy on delete set null
SQL
-1 vote214 views2 answers
Full join sql
SQL
6 votes222 views2 answers
Sql display max value
SQL
8 votes215 views1 answer
Oracle add month
SQL
3 votes224 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote237 views1 answer
Hoq to import database source
SQL
0 vote233 views1 answer
Sql select random procentage from rows
SQL
0 vote238 views1 answer
Select all columns except one sql
SQL