/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

0 vote180 views1 answer
Sql last 7 days
SQL
0 vote186 views1 answer
Oracle last connexion
SQL
-1 vote183 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote177 views1 answer
Mysql add root password
SQL
6 votes203 views2 answers
Mysql timestamp to date
SQL
0 vote206 views1 answer
"Hello User Name"
SQL
0 vote195 views1 answer
Postgres dump sql insert
SQL
1 vote185 views1 answer
Alter table column size oracle
SQL
10 votes182 views1 answer
Oracle dependencies table
SQL
0 vote185 views1 answer
Running query in redshift
SQL