Grant permissions to a user to grant select to specific tables in several schemas in Oracle
You probably want GRANT ANY OBJECT PRIVILEGE

AS DBA:

GRANT GRANT ANY OBJECT PRIVILEGE TO dwhmanager;


AS dwhmanager:

grant select on DWHFINANCE.SALES TO johndeveloper;


Presto!