/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 vote191 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote210 views1 answer
Synapse sql table set pk
SQL
0 vote229 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote179 views1 answer
Mysql case when on date
SQL
9 votes183 views4 answers
Mysql show table fields
SQL
10 votes175 views4 answers
Join with multiple conditions sql
SQL
3 votes188 views3 answers
Mysql select table names
SQL
0 vote190 views1 answer
Create schema sql server
SQL
0 vote193 views1 answer
Delete record by id sql
SQL
11 votes208 views1 answer
Oracle export view ddl
SQL