/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 vote292 views1 answer
Sqlite display data in separated columns
SQL
0 vote232 views1 answer
Excel vba import data to sql server
SQL
0 vote221 views2 answers
How to get last inserted id in sql server c#
SQL
1 vote208 views1 answer
Not exists mysql
SQL
1 vote225 views2 answers
Oracle list service names
SQL
5 votes214 views3 answers
String concatenation sql server
SQL
0 vote204 views1 answer
Sql how to display two atributes as one in sql
SQL
1 vote224 views1 answer
Oracle turn off constraint
SQL
0 vote229 views1 answer
To_date sql
SQL
13 votes215 views5 answers
Select last row mysql
SQL