in 11g databases (11.2.0), the DDL for user scripts does not save the passwords. any work around for 11gR2? Is this anyway related to TOAD version (Currently we have is 10.1.0.7)
in the DDL Options dialog, there might be a checkbox for “if possible, include ‘identified by values’ clause in 11g”.
I don’t remember which version of Toad that option first appeared.
In Oracle 11, Oracle made it harder to get to the password. It is no longer in dba_users. It’s only in sys.user$.
-John