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 vote121 views1 answer
Ef core 5.0 usesqlserver not found
SQL
11 votes144 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
2 votes114 views2 answers
How to view created temporary tables in mysql
SQL
0 vote131 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
1 vote118 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote132 views1 answer
Reindex mssql table
SQL
0 vote122 views1 answer
Vs 2019 connect to local mysql database
SQL
7 votes107 views3 answers
How ot change name of column mysql
SQL
3 votes126 views5 answers
Sql select
SQL
0 vote118 views1 answer
Update one column from another column in same table
SQL