/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

1 vote229 views2 answers
Mysql show views
SQL
0 vote229 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
7 votes221 views1 answer
Alter sequence set current value oracle
SQL
0 vote222 views2 answers
Sql server select where date
SQL
0 vote236 views4 answers
Postgresql between month
SQL
8 votes250 views1 answer
Oracle search text in all packages
SQL
7 votes232 views1 answer
Set sequence value oracle
SQL
0 vote230 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
8 votes226 views2 answers
Python simple connect to mysql
SQL
0 vote217 views1 answer
Oracle db get table sizes
SQL