/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 votes275 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote205 views1 answer
SQL division of an integer by another integer get float CAST
SQL
13 votes187 views2 answers
Sql join
SQL
0 vote194 views1 answer
Space not removing from column in sql
SQL
0 vote221 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote188 views1 answer
Database get 10 user aleatory
SQL
5 votes226 views2 answers
Postgresql add not null constraint
SQL
0 vote228 views1 answer
Get total and distict row diff in sql
SQL
2 votes174 views1 answer
Oracle sql drop column if exists
SQL
0 vote171 views1 answer
Sql script get all stored procedures from database
SQL