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

3 votes327 views2 answers
Postgresql select all column names
SQL
7 votes305 views1 answer
Grant schema permissions postgres
SQL
0 vote323 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote319 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote300 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote320 views1 answer
Psql list view rules
SQL
0 vote268 views1 answer
Mysql collation for all languages
SQL
2 votes365 views1 answer
Where clause for child record apex
SQL
2 votes308 views1 answer
Get first 3 letters name in sql
SQL
1 vote369 views3 answers
How to reset id column in sql server
SQL