/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

5 votes281 views3 answers
Db begintransaction laravel
SQL
0 vote290 views1 answer
Excel export from sql using python
SQL
0 vote268 views1 answer
Datagrip exec
SQL
1 vote261 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote292 views1 answer
Sql express database size limit
SQL
0 vote265 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote251 views1 answer
Select value from previous row in postgresql
SQL
0 vote295 views1 answer
How to map sql column to custom names
SQL
32 votes300 views6 answers
Insert select
SQL
2 votes318 views3 answers
How to replace null values in sql
SQL