/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 vote285 views1 answer
Select all domains of database firbird
SQL
1 vote326 views2 answers
Change table name phpmyadmin
SQL
0 vote364 views1 answer
Oracle show grants on table
SQL
0 vote337 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote308 views1 answer
How to count with except in psql
SQL
0 vote317 views1 answer
How to use lower case in mysql
SQL
0 vote323 views2 answers
Sql query for getting details by id
SQL
18 votes304 views2 answers
Sql comments
SQL
1 vote326 views3 answers
Update from select sqlite
SQL
0 vote343 views1 answer
Mysql 5.7 in centos 7
SQL