/SQL/Oracle grant on all tables in schema

Oracle grant on all tables in 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 vote169 views1 answer
Mysql count by month
SQL
4 votes173 views2 answers
How to count items with same name in sql
SQL
4 votes193 views2 answers
Oracle unlock account
SQL
0 vote185 views2 answers
List all constraints in postgres
SQL
1 vote222 views1 answer
Sample clause in sql
SQL
0 vote236 views1 answer
Select * where id = 1,2,3
SQL
0 vote169 views1 answer
Postgresql like
SQL
5 votes181 views2 answers
Postgres update with if condition query
SQL
0 vote191 views1 answer
Select new table sql
SQL
1 vote249 views3 answers
Date_add mysql
SQL