/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 vote128 views2 answers
Mysql calcular idade
SQL
0 vote119 views1 answer
Rabbitmq service not starting
SQL
24 votes125 views5 answers
Sql reset auto increment
SQL
0 vote126 views1 answer
Sql tabelle erstellen
SQL
2 votes113 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
-1 vote130 views2 answers
Full join sql
SQL
2 votes123 views1 answer
Anonymous block plsql
SQL
0 vote122 views1 answer
Create table sql generator
SQL
0 vote165 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
5 votes212 views2 answers
Mysql date greater than 30 days
SQL