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

31 votes112 views4 answers
Mysql grant execute
SQL
0 vote118 views1 answer
How we can perform acid Operations in sql with examples
SQL
7 votes103 views1 answer
Oracle set sequence value to max(id)
SQL
8 votes111 views1 answer
Mac restore mysql database command line
SQL
2 votes105 views2 answers
Created at and updated at in mysql
SQL
1 vote109 views1 answer
Drop column if exists sql server
SQL
1 vote105 views1 answer
Mariadb get column names from table
SQL
2 votes107 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote104 views1 answer
Create a table from one field of another table
SQL
1 vote111 views1 answer
Postgres count string length
SQL