Answers for "oracle grant on all tables in schema"

SQL
1

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;
Posted by: Guest on February-22-2021

Code answers related to "oracle grant on all tables in schema"

Code answers related to "SQL"

Browse Popular Code Answers by Language