This section describes new connectivity features in version 10.4.0.
User Impersonation for Oracle Connections
Effective in version 10.4.0, you can specify the impersonate user name in the Oracle connection in PowerCenter to connect to Oracle sources and targets. When you specify an impersonate user, you can connect to Oracle on behalf of that user and perform read or write operations.