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

6 votes192 views1 answer
Wordpress change user password sql
SQL
1 vote217 views1 answer
What is in condition in sql
SQL
0 vote206 views1 answer
Postgresql concat string with separator
SQL
5 votes203 views4 answers
Upload database mysql command line
SQL
0 vote211 views1 answer
Sql: extract day text from datetime value
SQL
2 votes195 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote182 views1 answer
Java sql connection
SQL
0 vote194 views1 answer
Turnicate in mysql
SQL
0 vote203 views1 answer
Manage Database in MySQL
SQL
1 vote216 views1 answer
Trim leading zeros in sql
SQL