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 vote273 views1 answer
Php insert null mysql
SQL
0 vote219 views1 answer
Ver usuarios mysql
SQL
0 vote213 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote240 views1 answer
Java sql timestamp now
SQL
0 vote223 views1 answer
Mysql search like but first exact match
SQL
6 votes221 views1 answer
Oracle trigger after logon on database
SQL
2 votes245 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
2 votes227 views2 answers
Create table mysql integer NOT null
SQL
4 votes227 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
8 votes222 views3 answers
SQL column name
SQL