/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 vote257 views1 answer
Psql datestyle
SQL
0 vote299 views1 answer
Find and replace query in wordpress\
SQL
0 vote243 views1 answer
Sql count * vs count 1
SQL
11 votes262 views4 answers
MYSQL LOGIN
SQL
1 vote253 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote259 views1 answer
Datetime postgres typeorm
SQL
15 votes266 views4 answers
Mysql where value is null
SQL
3 votes247 views1 answer
Oracle user quota unlimited
SQL
1 vote266 views1 answer
Convert varchar to int in sqlite
SQL
0 vote231 views1 answer
Sql requete number pair
SQL