/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 vote184 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote155 views1 answer
How to select even id in sql
SQL
1 vote110 views1 answer
Convert money to varchar sql server
SQL
0 vote170 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote185 views5 answers
Select concat alter table mysql
SQL
1 vote154 views1 answer
SQL Integer devision
SQL
0 vote160 views1 answer
Time mysql w3
SQL
0 vote156 views1 answer
Mysql wait_timeout
SQL
1 vote154 views2 answers
Oracle list service names
SQL
0 vote138 views2 answers
How to get json data mysql
SQL