/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 vote129 views2 answers
Mysql set foreign_key_checks=0
SQL
23 votes137 views5 answers
Sql substring
SQL
1 vote136 views1 answer
Window function mysql
SQL
3 votes141 views1 answer
Get all elements sql
SQL
0 vote155 views1 answer
Sql from null to not null
SQL
1 vote187 views1 answer
Mysql is odd
SQL
3 votes139 views4 answers
Truncate syntax in sql
SQL
9 votes135 views4 answers
Mysql show table fields
SQL
0 vote144 views1 answer
Merge clause with inner join
SQL
0 vote140 views1 answer
Systemverilog unique constraint unique values
SQL