Using Oracle Proxy Users

[gokce]

Hi,
We need to use proxy user feature of Oracle for one of our production databases in order to connect on behalf of another user.
But when we try to login as "USER_A[USER_B]/password_A", we're getting invalid username/password error.
We're not having problem with Oracle SQL Developer. Is there a way to login with proxy user in PL/Sql Developer?

 

[Marco Kalter]

Can you let me know which PL/SQL Developer version you are using?

 

[gokce]

Version 9.0.2.1621.

 

[Marco Kalter]

Can you try again with the current 11.0.4 version? A trial version is available on our web site.

 

[gokce]

I already downloaded the trial of Version 11.0.4.1774.
Unfortunatelly I'm getting the same error.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[gokce]

I send the debug.txt file to Allround Automations Support .

 

[gokce]

I solved the problem.
I'm using 10G oracle client. (becuase I'm getting error with 11G 64 bit client, (error was about oci.dll))
I installed 32 bit 11g client. And selected its oci.dll in the tools->preferences->oracle->connection oci library section.
It's ok now, with 9.0.2 version, I can connect with proxy users..

 

[Arky]

Marco,

does the tool support connection via proxy user providing also a password for him?
I mean, other then the form
USER_A[USER_B]/password_A
which is supported,

is the following one supported also?
USER_proxy[USER_B/password_B]/password_proxy

 

[Marco Kalter]

There is currently no support for this. We'll investigate.