Database link with proxy user [message #681770] |
Fri, 28 August 2020 04:29 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I would like to create a db link connection through a proxy user. This doc
Bug 19191702 - Proxy user database link fails with ORA-01017 / ORA-02063 in 11.2.0.4 and above - event to allow old behaviour (Doc ID 19191702.8 )
says that it is not meant to work. It used to work up 11.2.0.3 but then they broke it, and the previous (working!) behaviour is described as "incorrect". Thank you, Larry. A work around that should make it work is supposed to be
Quote:However, as users might rely on the old
behaviour this fix provides a way to revert to pre-11.2.0.4 behaviour by setting event 19191702 to level 1.
This change is included in 12.2 and above. Hoewever, this does not work for me in 19.x with or without the event set:orclz>
orclz> alter user system grant connect through scott;
User altered.
orclz> create database link l1 connect to "SCOTT[SYSTEM]" identified by tiger using 'orclz';
Database link created.
orclz>
orclz> select * from global_name@l1;
select * from global_name@l1
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from L1
orclz> alter session set events '19191702 level 1';
Session altered.
orclz> select * from global_name@l1;
select * from global_name@l1
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from L1
orclz> Am I setting the event correctly?
Thank you for any insight.
|
|
|
|
Re: Database link with proxy user [message #681777 is a reply to message #681776] |
Fri, 28 August 2020 09:05 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
If, as you say, their doc says it was not meant to work, then they didn't break it, they fixed it. I've been in this business since 1981, and can attest that the landscape is littered with code that depended on undocumented or unintended behavior, then broke when the vendor plugged the hole.
|
|
|