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 vote269 views1 answer
Find size of all DB's postgres
SQL
0 vote229 views1 answer
Postgressql uuid
SQL
1 vote252 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote237 views1 answer
Difference between db.query and db.execute
SQL
0 vote233 views1 answer
Mysql insert into select with recursive
SQL
4 votes190 views3 answers
Create table if not exists postgresql
SQL
0 vote253 views1 answer
Get primary key of table
SQL
0 vote231 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
92 votes389 views6 answers
Substring
SQL
0 vote264 views1 answer
Min:sec datediff mssql
SQL