Oracle grant select on 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

13 votes152 views2 answers
Display users in mysql
SQL
0 vote253 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
4 votes170 views3 answers
Drop Table Oracle
SQL
0 vote208 views2 answers
How to prevent sql injection in java
SQL
2 votes175 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote156 views1 answer
Get duplicate entry sql
SQL
2 votes145 views1 answer
Oracle sql query to make column data uppercase
SQL
1 vote153 views1 answer
Get rows affected mysql python
SQL
10 votes162 views6 answers
Between sql
SQL
0 vote158 views1 answer
Create mysql pool connection python flask
SQL