/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

1 vote322 views1 answer
Oracle sql first day of year
SQL
1 vote296 views1 answer
Mysql monthname
SQL
1 vote300 views2 answers
Mysql remove first and last character from string
SQL
0 vote312 views2 answers
Update information in a mysql column
SQL
0 vote342 views2 answers
Mysql insert into multiple tables
SQL
7 votes292 views4 answers
Database dump mysql command
SQL
32 votes316 views6 answers
Sql count where
SQL
6 votes282 views1 answer
SQL insert all columns
SQL
2 votes313 views3 answers
Sql interview query questions
SQL
0 vote300 views1 answer
Sql server datetime to string
SQL