/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

20 votes140 views5 answers
Mysql reset auto increment to 1
SQL
10 votes154 views1 answer
How to import database in mysql by cmd
SQL
0 vote143 views1 answer
Sql sort ages
SQL
0 vote139 views1 answer
Oracle current timestamp insert statement
SQL
0 vote158 views1 answer
Truncate a table then insert data
SQL
0 vote140 views1 answer
Drop specific row postgresql
SQL
1 vote155 views1 answer
Ubuntu access database from terminal
SQL
1 vote134 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote139 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote148 views1 answer
Ms sql filter all sympbol
SQL