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 vote308 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote271 views1 answer
Mysql select update same table
SQL
5 votes262 views1 answer
Update sql user password
SQL
0 vote301 views1 answer
Doctors appointment
SQL
0 vote289 views1 answer
Mysql multiple primary keys
SQL
0 vote270 views1 answer
Joins vs includes
SQL
-1 vote288 views1 answer
How to dump .csv file into mysql
SQL
5 votes295 views1 answer
How to get all table names in sql query
SQL
3 votes303 views5 answers
Duplicate table sql
SQL
3 votes277 views1 answer
Sql replace character in string in all records
SQL