Toad doesn't save the connection information correctly when working with a proxy connection setup.
Sample:
ALTER USER scott GRANT CONNECT THROUGH test_user;
Connect in Toad Data Point as my_username[proxy_username]/test_user. This connects.
Disconnect then try to double click and reconnect through the saved connection in Toad. It errors out
"ORA-01017: invalid username/password; logon denied"
Looking at the properties of the saved connection, it shows that the user/schema name saved as the original user name, "proxy_username", not the proxy user, "my_username[proxy_username]".
WORKAROUND:
None
STATUS:
Fixed in version 3.4 of Toad Data Point. The latest version can be download from the Support Portal.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center