In Toad for Oracle v9.1, when logging in with an Oracle schema named EXTERNAL, the following error occurs:
"ORA-01017: invalid username/password; login denied."
Able to connect with EXTERNAL with password using SQL*PLUS, Oracle Enterprise manager and TOAD for Oracle v8.6.
Why is TOAD 9.1.0.62 causing an error?
EXTERNAL is a schema name that is not supported by Toad. Toad supports OS authenticated logins and in order to distinguish between an OS authenticated login and a typical login, Toad uses EXTERNAL as a dummy username internally for years.
What is really happening is that Toad recognizes the username EXTERNAL and thinks that it is an OS authenticated login so it is stripping the username when connecting to Oracle.
Workaround:
Use double quotes in the username so that "EXTERNAL" appears in the user edit box on the login window.
