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

24 votes102 views2 answers
Alter table delete column
SQL
0 vote140 views1 answer
Sql create and grant user access to database
SQL
14 votes126 views3 answers
Inner join sql oracle
SQL
0 vote107 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote114 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
5 votes120 views1 answer
Oracle nls parameters
SQL
2 votes104 views1 answer
Sql as
SQL
34 votes107 views6 answers
Sql change data type
SQL
1 vote117 views1 answer
Tsql find foreign key references
SQL
1 vote119 views1 answer
Show structure of table in sql
SQL