/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 vote133 views1 answer
Inser into example
SQL
0 vote170 views1 answer
Sql remove non numeric characters
SQL
0 vote143 views1 answer
Order by monthly in sql
SQL
2 votes143 views1 answer
Sql alchemy or
SQL
0 vote175 views1 answer
Sql waitfor
SQL
1 vote175 views1 answer
Sql server set variable if exists
SQL
2 votes184 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote166 views1 answer
Format the money fied with comma in international system using sql
SQL
7 votes118 views1 answer
Mysql load data infile csv
SQL
0 vote145 views1 answer
Mysql create table columns with spaces
SQL