/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

2 votes201 views1 answer
Oracle convert run_duration to number
SQL
1 vote224 views1 answer
Postgres power
SQL
6 votes235 views6 answers
Rename column postgres
SQL
0 vote191 views1 answer
Mssql now diff 90 day
SQL
1 vote244 views1 answer
Add time to date sql
SQL
2 votes202 views1 answer
How to find table table in stored procedure sql server
SQL
9 votes205 views2 answers
Sql limit to 5 results
SQL
0 vote205 views1 answer
Pass array parameter to stored procedure c#
SQL
1 vote235 views1 answer
Psql client write to bash variable
SQL
12 votes281 views4 answers
How to drop all tables in postgresql
SQL