/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 vote149 views1 answer
One table with another
SQL
0 vote159 views1 answer
Snowflake drop column
SQL
0 vote160 views1 answer
Safe mysql
SQL
1 vote141 views1 answer
What is in condition in sql
SQL
21 votes135 views6 answers
Change column in mysql
SQL
0 vote135 views1 answer
Sql trim whitespace
SQL
7 votes141 views2 answers
Add column table pl sql
SQL
0 vote167 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote142 views1 answer
Dbms_output sql developer
SQL
0 vote153 views1 answer
Query string starts with vowels
SQL