/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 vote333 views1 answer
Oracle sql date summer time
SQL
0 vote422 views1 answer
Comparing with today and yesterday record in sql query
SQL
7 votes377 views1 answer
Oracle alter sequence restart start with
SQL
0 vote340 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote358 views1 answer
Turnicate in mysql
SQL
0 vote362 views1 answer
Postgresql interview questions
SQL
6 votes374 views2 answers
Mysql timestamp to date
SQL
0 vote354 views1 answer
Sql server isnull function nor working count
SQL
2 votes370 views1 answer
Update with join sql server
SQL
1 vote344 views1 answer
Real world example of nosql
SQL