/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 vote171 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote211 views1 answer
Calculer pourcentage mysql
SQL
0 vote204 views3 answers
Join
SQL
0 vote197 views1 answer
Least spark sql
SQL
0 vote202 views2 answers
Identity syntax in sql
SQL
0 vote183 views1 answer
Sql server select record with max id
SQL
0 vote174 views1 answer
Sql composite key
SQL
0 vote167 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote199 views1 answer
Postgresql not in
SQL
23 votes189 views4 answers
How to uninstall postgresql in ubuntu
SQL