/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 vote176 views1 answer
Sql set auto increment back to 0
SQL
2 votes113 views1 answer
Foreign key example in dbms
SQL
1 vote162 views1 answer
Name of today sql
SQL
1 vote171 views1 answer
Sql server get users
SQL
5 votes149 views1 answer
Oracle scan source ddl
SQL
14 votes172 views4 answers
Online sql compiler
SQL
0 vote151 views3 answers
Get free card roblox
SQL
3 votes165 views1 answer
Select database in sql
SQL
2 votes155 views1 answer
Oracle find constraints referencing a table
SQL
3 votes151 views1 answer
Laravel paginate raw sql
SQL