/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 votes145 views2 answers
Mysql on duplicate key update get value from values
SQL
2 votes171 views2 answers
Null column to 0 in mysql
SQL
0 vote151 views2 answers
PostgreSQL having
SQL
1 vote86 views1 answer
Metada in sql
SQL
0 vote161 views2 answers
Clauses in mysql
SQL
0 vote126 views1 answer
Order by ip address sql
SQL
4 votes131 views4 answers
Start mysql
SQL
5 votes173 views3 answers
Create function in postgresql
SQL
0 vote126 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote145 views1 answer
Disable database droping sql
SQL