Home » RDBMS Server » Networking and Gateways » Database link with proxy user (DB19.x)
Database link with proxy user [message #681770] Fri, 28 August 2020 04:29 Go to next message
John Watson
Messages: 8922
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 #681776 is a reply to message #681770] Fri, 28 August 2020 08:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I tried and got the same thing in 19.8 EE on Windows.

Re: Database link with proxy user [message #681777 is a reply to message #681776] Fri, 28 August 2020 09:05 Go to previous message
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.
Previous Topic: Oracle to Sql server
Next Topic: ORA-12541: TNS:no listener". (.Net SqlClient Data Provider) (2 merged)
Goto Forum:
  


Current Time: Thu Mar 28 10:57:59 CDT 2024