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 vote193 views1 answer
Rows to comma separated values in mssql
SQL
0 vote183 views1 answer
T-sql delete view if exists
SQL
0 vote193 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
35 votes174 views6 answers
Postgres
SQL
10 votes189 views2 answers
Oracle alter sequence nextval
SQL
0 vote156 views1 answer
INSERT INTO table using OpenQuery
SQL
3 votes185 views2 answers
Update Query in SQL Server
SQL
1 vote164 views1 answer
How to make a select in sql
SQL
16 votes170 views1 answer
CTE statement sql server
SQL
0 vote189 views1 answer
Mysql extract day from date leading zero
SQL