/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 votes339 views2 answers
Set database timezone mysql
SQL
2 votes359 views1 answer
SQL IF ELSE
SQL
3 votes329 views2 answers
Mysql add 2 hours
SQL
1 vote363 views1 answer
Woocommerce mysql price table
SQL
0 vote367 views1 answer
Typeorm raw sql
SQL
1 vote358 views2 answers
List tables sqlalchemy
SQL
2 votes341 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote328 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote333 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
1 vote366 views1 answer
Add many column to sap iq table
SQL