When checking the following script option in the Schema Browser User script:
"If possible include the 'Identified by values' clause in 11g"
TOAD only includes the new SPARE4 column value in User$ -- the new 11g Password Hash Value -- TOAD does NOT include the Old Hash Value, and thus, it is lost. With the database sec_case_sensitive_logon parameter set to false, the user is still required to enter the correct case.
Â
WORKAROUND:
Amend script to include the 'Password' value e.g.
alter user JBLOGG identified by values '<spare4 value>;<password value>'
STATUS
Issue fixed in version 10.6.1. The latest version of Toad for Oracle can be downloaded here .