add support for oracle proxy users

Hi, jdbc does support it, dbvis not (that I could find). In sqlplus we can connect with username[proxyuser_name]. A similar syntax would be very welcome. a nice example for a java connection is here: best regards, Ronald http://ronr.blogspot.com

Hi Roger, using sqlplus I can, using dbvis, I can't. It would be nice if this could be done. What I tried is: jdbc:oracle:thin:{pool_user}/@{host}:{port}:{ORACLE_SID} and this results in An error occurred while establishing the connection: Long Message: unsupported verifier type Details:    Type: java.sql.SQLException    Error Code: 17451    SQL State: 99999 private void proxyConnection() throws Exception { 02 Properties properties = new Properties(); 03 properties.put("PROXY_USER_NAME", "pu_user_1"); 04 05 OracleConnection conn = (OracleConnection) DriverManager.getConnection( 06 "jdbc:oracle:thin:pu_pool_user/pu_pool_user@localhost:1521:ora1012", 07 properties); 08 conn.openProxySession(OracleConnection.PROXYTYPE_USER_NAME, properties); I fail to see how I can make dbvis open the ProxySession by tweeking the driver properties. If you have a pointer, I will be more than happy to try that. best regards, Ronald.