/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 vote356 views1 answer
How to delete python anywhere mysql database
SQL
1 vote333 views3 answers
Mariadb add foreign key
SQL
-1 vote330 views2 answers
Full join sql
SQL
13 votes382 views4 answers
What is sql
SQL
0 vote374 views1 answer
Sql delete caracter list
SQL
8 votes374 views3 answers
Postgres connection string
SQL
4 votes354 views1 answer
T-sql get duplicate rows
SQL
1 vote355 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote338 views1 answer
Mysql replication change database name
SQL
0 vote367 views2 answers
Suse stop MySQL
SQL