Support for proxy user

[AndreDeslauriers]

Is there any plan to add support for proxy user?
I am using v9.0.6
Thx.

 

[Marco Kalter]

This is on the list of enhancement requests, but we don't have a time frame yet.

 

[AndreDeslauriers]

I am not sure that

 

[AndreDeslauriers]

I am not sure that we are taking about the samething,
I am just trying to connect into Oracle with that syntax below, in the that command windows of yours.

CONNECT ANY_DOG[GOOFY]/WELCOME@MYSID

That does not work in PL/SQL, it raise an ora-01017 error.

The same connect works flawlessly in sqlplus.

Try this example with sqlplus /nolog

CREATE USER ANY_DOG IDENTIFIED BY WELCOME;
GRANT CONNECT TO ANY_DOG;
CREATE USER GOOFY IDENTIFIED BY WELCOME;
GRANT CREATE SESSION TO GOOFY;
ALTER USER GOOFY GRANT CONNECT THROUGH ANY_DOG;

CONNECT ANY_DOG[GOOFY]/WELCOME@YOURSID

SELECT USER REAL_USER, SYS_CONTEXT('USERENV', 'PROXY_USER') PROXY_USER FROM DUAL;

You should see :

REAL_USER PROXY_USER
------------------------- -----------
GOOFY ANY_DOG

It should not be to hard to implement ????

Thx

REF:https://blogs.oracle.com/jheadstart/entry/using_proxy_authentication

 

[Jeff81]

This works for me in PL/SQL Developer 9.0.6 in a command window.

 

[AndreDeslauriers]

It was a setup error.

In PL/SQL, the Oracle Home was set to 920, instead of blank (automatic)

Thx

 

[Jeff Ward]

Do you know when proxy support will be added?

We have been using PL/SQL developer for years and love it but audit require us to start using proxy connections and so if this doesnt work we will have to switch to oracle SQL Developer!

 

[Jeff Ward]

Jeff81, I have just upgraded to the latest version from 9.0.4 to 9.0.6.1665 and tried this from a command window and this didnt work, how did you get yours to work?

I tried the format user1[user2]/password@SID and it just came up invalid password and brought up the logion dialog screen

 

[Jeff Ward]

Actually i think i have sorted this
My oracle home was set to an Oracle 10 client so i have switched it to use an Oracle 11 client and i have now managed to do a proxy connection

 

[amit3131]

I am looking to get the proxy user work through Oracle Forms 10g and its giving the invalid password error. Though it is working fine through the 10g SQL Plus command prompt using the format
user1[user2]/password@SID

Please suggest if there is any way to make it work through Oracle Forms 10g.