/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 vote171 views1 answer
Difference berween database and data base management system
SQL
3 votes132 views1 answer
Make a field auto_increment mysql
SQL
0 vote131 views1 answer
How to find columns with null values in sql
SQL
0 vote129 views2 answers
Temp tables in sql server
SQL
3 votes148 views2 answers
Sql not contains
SQL
24 votes132 views4 answers
Postgres remove database
SQL
0 vote166 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
1 vote128 views1 answer
Truncate left characters mysql
SQL
0 vote128 views1 answer
Sql: extract day text from datetime value
SQL
0 vote127 views1 answer
Procedure excute monthly oracle
SQL