/SQL/Oracle grant on all tables in schema

Oracle grant on all tables in 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 vote276 views1 answer
Mysql listing get a particu particular user firsdt
SQL
4 votes253 views2 answers
Dbms_scheduler stop job
SQL
3 votes274 views1 answer
Oracle drop user
SQL
0 vote268 views1 answer
Sqlalchemy query join many to many
SQL
10 votes272 views1 answer
User_dependencies
SQL
123 votes436 views5 answers
Sql where contains
SQL
2 votes257 views1 answer
Create table with primary key
SQL
0 vote329 views1 answer
Drop table BigQuery table columns
SQL
61 votes429 views6 answers
Mysql add column
SQL
1 vote252 views1 answer
Mysql show current queries
SQL