Oracle Grant Privileges to ETL Account

Create Read Only Role

Login as Objects Owner
CREATE ROLE OWNER_READONLY;
GRANT SELECT ANY TABLE TO OWNER_READONLY;
GRANT SELECT ANY TRANSACTION TO OWNER_READONLY;

Grant Role to user

Login as sys
GRANT OWNER_READONLY TO DW_ETL;