/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 vote289 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote263 views2 answers
Sql where keyword
SQL
1 vote291 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote264 views1 answer
Oracle enable chain
SQL
0 vote293 views1 answer
Csv to sqlite python
SQL
1 vote292 views1 answer
Mysql select for update ejemplo
SQL
1 vote271 views1 answer
Oracle stop job
SQL
0 vote286 views1 answer
Drop procedure sql
SQL
1 vote268 views1 answer
Select from one table where not on the other
SQL
2 votes468 views5 answers
Unique in sql server
SQL