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

0 vote105 views2 answers
Postgresql could not start server mac
SQL
17 votes155 views2 answers
T_sql contains
SQL
0 vote207 views1 answer
Postgres rename database
SQL
8 votes152 views2 answers
Alert table name mysql
SQL
0 vote139 views1 answer
Online sql testing tool
SQL
0 vote147 views1 answer
How to check xampp mysql password
SQL
1 vote145 views2 answers
Sql groub by count
SQL
-1 vote164 views1 answer
Capitole toulouse
SQL
0 vote142 views2 answers
Imageview setimageresource null
SQL
5 votes150 views3 answers
Sql make column nullable
SQL