/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

1 vote197 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
4 votes231 views4 answers
Check constraint in ms sql
SQL
7 votes169 views2 answers
Sql server drop temp table if exists
SQL
2 votes185 views3 answers
Current setting postgres timezone
SQL
6 votes189 views4 answers
Mysql group by date
SQL
22 votes176 views4 answers
Mysql date_format
SQL
0 vote230 views1 answer
Drop view sql
SQL
2 votes173 views1 answer
Mysql create user with remote access
SQL
0 vote176 views1 answer
Postgresql on conflict pair
SQL
0 vote165 views1 answer
Concat column value of same user in mysql
SQL