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