Re: Connecting to O8i as a proxy?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 28 Oct 1999 21:31:41 -0400
Message-ID: <u=gYOIgluqMUV72VBqOB7xeGjets@4ax.com>

A copy of this was sent to njoneill_at_llnl.gov (if that email address didn't require changing) On Fri, 29 Oct 1999 01:03:40 GMT, you wrote:

>The SQL ALTER USER command has a proxy clause that "controls the
>ability of a proxy (an application or application server) to connect as
>the specified user." But this just sets up a permission. I can find no
>information on how the actual connection to the database is made. How
>do I tell Oracle that, although I'm really John, I want to connect as
>Bob. I'm particularly interested in how this might be done using JDBC.
>

don't think you can do this with java/jdbc as yet. its an OCI specific call. see the website (OCI N-Tier Authentication (HOWTO)) in my signature for more info on this particular feature.

>--N. J. O'Neill
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Oct 28 1999 - 20:31:41 CDT