/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 vote208 views1 answer
Test database for sql
SQL
1 vote185 views1 answer
Sql Split string function
SQL
0 vote191 views1 answer
Fast sql column count
SQL
0 vote219 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
1 vote175 views1 answer
Ms sql - add one hour to time
SQL
2 votes209 views1 answer
Mysql select default if null
SQL
0 vote233 views1 answer
Get only one row in mysql
SQL
0 vote253 views1 answer
Python mysql executemany
SQL
0 vote206 views1 answer
Sub query in linq
SQL
3 votes205 views2 answers
Oracle for loop
SQL