/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 vote353 views1 answer
Mysql where in maintain order
SQL
0 vote363 views1 answer
Distance calculator from lat long sql query
SQL
1 vote329 views1 answer
Psql datetime grather than
SQL
5 votes322 views1 answer
Mysql get last day of month
SQL
7 votes322 views3 answers
Sql get last inserted row
SQL
0 vote299 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote640 views1 answer
How to connect .sql data set to powerbi
SQL
4 votes323 views1 answer
Oracle delete last row
SQL
0 vote336 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote332 views1 answer
Postgresql not in alternative
SQL