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]".
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center