The Oracle driver supports reauthentication for Oracle 8.1.6 and higher. The user performing the switch must have been granted the database permission CONNECT THROUGH.
See Using Reauthentication for an introduction to reauthentication. Refer to "Connection Pool Manager" in the DataDirect Connect Series for JDBC Reference for information about using reauthentication with the DataDirect Connection Pool Manager.
Note: Before performing reauthentication, applications must ensure that any statements or result sets created as one user are closed before switching the connection to another user.
Your application can use the setCurrentUser() method in the ExtConnection interface to switch a user on a connection. Optionally, the setCurrentUser() method accepts driver-specific reauthentication options; however, no options are supported for the Oracle driver. Refer to "JDBC Extensions" in the DataDirect Connect Series for JDBC Reference for more information about the setCurrentUser() method.