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

4 votes367 views3 answers
Copy table postgres
SQL
1 vote357 views1 answer
Oracle character set
SQL
1 vote370 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
10 votes338 views3 answers
Sql limit results
SQL
1 vote348 views1 answer
Column with prefix in sql
SQL
0 vote367 views1 answer
Postgres clear table
SQL
13 votes382 views5 answers
Alter table query sql server change column
SQL
0 vote341 views1 answer
On update current_timestamp jpa
SQL
0 vote359 views2 answers
Postgres another version
SQL
9 votes381 views2 answers
Sql server check table exists
SQL