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.

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 Connection Pool Manager in the Progress DataDirect for JDBC Drivers Reference for more information.

Refer to JDBC extensions in the Progress DataDirect for JDBC Drivers Reference for more information about the setCurrentUser() method.