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  |
John Watson
Messages: 8976 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.
|
|
|
|
|
Goto Forum:
Current Time: Sat May 03 18:35:04 CDT 2025
|