Grant permissions to all tables in schema
BEGIN FOR TAB_NAME IN (SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ‘‘ ) LOOP EXECUTE IMMEDIATE ‘GRANT SELECT ON ‘ || TAB_NAME.TABLE_NAME || ‘ TO ‘; END LOOP; END;
BEGIN FOR TAB_NAME IN (SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ‘‘ ) LOOP EXECUTE IMMEDIATE ‘GRANT SELECT ON ‘ || TAB_NAME.TABLE_NAME || ‘ TO ‘; END LOOP; END;