/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

2 votes383 views2 answers
Mysql compare datetime to another datetime
SQL
2 votes328 views2 answers
Select list is not in group by clause
SQL
0 vote338 views1 answer
Windows services sql
SQL
0 vote317 views1 answer
Mysql error codeigniter
SQL
3 votes347 views2 answers
Sqlite print all column names
SQL
2 votes337 views2 answers
Compare date mysql
SQL
10 votes341 views2 answers
Linux command line import mysql database
SQL
56 votes632 views5 answers
Psql create user
SQL
0 vote376 views1 answer
SQL server datetime compare
SQL
0 vote365 views1 answer
Rename constraint postgresql
SQL