/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 vote72 views1 answer
Mysql sleep connections
SQL
1 vote121 views1 answer
Pl sql create table from another table
SQL
6 votes151 views2 answers
Oracle compile trigger
SQL
0 vote120 views1 answer
Mysql changer nom table
SQL
1 vote120 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
2 votes114 views1 answer
Import database in mysql command line xampp
SQL
15 votes111 views2 answers
How to drop database name in postgresql
SQL
0 vote136 views1 answer
Delete a temporary table mysql
SQL
0 vote119 views1 answer
Mariadb cast to int
SQL
4 votes123 views1 answer
Mysql ip address data type
SQL