/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 vote249 views1 answer
Mysql datetime with timezone offset
SQL
0 vote248 views1 answer
Oracle running queries
SQL
12 votes252 views2 answers
Insert multiple rows from another table sql
SQL
16 votes252 views6 answers
Install sqlite3 python
SQL
0 vote232 views1 answer
Sql server pivot rows to columns
SQL
1 vote217 views1 answer
MySQL AND Operator
SQL
0 vote291 views1 answer
Intellij mysql set timezone
SQL
5 votes238 views1 answer
Sysdate in oracle sql
SQL
1 vote241 views1 answer
Sql server 2012 query history
SQL
0 vote231 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL