/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 vote199 views1 answer
Show per page table in xampp
SQL
0 vote202 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote214 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote216 views1 answer
Postgresql linux password
SQL
0 vote208 views2 answers
Get top 1 row of each group
SQL
2 votes192 views1 answer
Update trigger
SQL
0 vote192 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote201 views1 answer
Enable full text search mysql
SQL
3 votes208 views3 answers
Start postgresql ubuntu
SQL
0 vote205 views1 answer
Sql database connectivity
SQL