oracle grant on all tables in schema

Solutions on MaxInterview for oracle grant on all tables in schema by the best coders in the world

showing results for - "oracle grant on all tables in schema"
Paula
26 Sep 2019
1BEGIN
2   FOR R IN (SELECT owner, table_name FROM all_tables 
3             WHERE owner='OTHER_SCHEMA') LOOP
4      EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||
5                         R.owner || '.' || R.table_name || ' TO MY_SCHEMA';
6   END LOOP;
7END;