Is this possible to rename my connection (with new user Id/password) after
my application server is connected to Oracle8i? I want to use the same
connection because i would like that the audit is carried out on the level
of the database and not on the level of the application. I do not want to
preserve the connection initial because it is not a name (userId) of the
person having to carry out the changes in the database. It would be
impossible to know which carries out the changes in the database if we keep
the initial connection of the server of application.
Example:
Initail connection by the application server:
String driverName = "oracle.jdbc.driver.OracleDriver";
connectStr="jdbc:oracle:thin:SERVER_APPLICATION/PASSWORD_SERVER_APPLICATION_at_
IP-Adress:Port:SID
I want, after the connection is established, to change the
SERVER_APPLICATION for another USERID.
- Is this possible to change the USER with JDBC or Stored Procedure?
