/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

6 votes165 views1 answer
Sql insert values into table
SQL
28 votes102 views4 answers
Show tables mysql
SQL
1 vote106 views6 answers
In sql
SQL
0 vote109 views1 answer
How to query without duplicate rows in sql
SQL
1 vote100 views2 answers
Grab part of a string sql
SQL
0 vote113 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote106 views1 answer
Start and stop mysql
SQL
6 votes134 views3 answers
Rename column ORACLE
SQL
0 vote116 views1 answer
Sql anywhere create procedure
SQL
4 votes96 views2 answers
Postgresql reset sequence
SQL