/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

7 votes292 views2 answers
Oracle foreign key reference table
SQL
0 vote236 views1 answer
Postgresql add leading zeros
SQL
0 vote321 views1 answer
For select oracle
SQL
0 vote291 views1 answer
Oracle activate program
SQL
1 vote427 views3 answers
Uninstall postgresql mac
SQL
0 vote290 views1 answer
Inserted row count tsql
SQL
0 vote309 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote293 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote300 views1 answer
Drop-toys-table
SQL
3 votes278 views1 answer
Oracle user quota on tablespace
SQL