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 vote119 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote133 views1 answer
Postgres sequence name
SQL
37 votes118 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
3 votes117 views2 answers
Postgresql remove not null constraint
SQL
1 vote110 views1 answer
Mysql sort by date column
SQL
1 vote121 views1 answer
Psql lst trigger
SQL
25 votes119 views3 answers
Mysql command show tables
SQL
0 vote118 views1 answer
Postgres week number
SQL
0 vote127 views1 answer
How to start my sql server on mac
SQL
1 vote111 views1 answer
Sql select contem uma palavra
SQL