/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 vote214 views1 answer
What does leave do in mysql
SQL
0 vote212 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
9 votes219 views3 answers
Import DB through mysql console
SQL
12 votes214 views4 answers
How to check mysql version ubuntu
SQL
0 vote200 views1 answer
Select last 2 characters sql
SQL
17 votes200 views6 answers
Sql select distinct
SQL
13 votes204 views5 answers
Alter table query sql server change column
SQL
1 vote197 views1 answer
How to update date add hours in postgresql
SQL
0 vote300 views1 answer
How to login to mysql in homestead
SQL
6 votes250 views2 answers
Oracle compile trigger
SQL