RE: how to generate create user script with password in TOAD

Due to changes in 11G in the way passwords are done (in order to support case sensitive passwords) this is the way it has to work. Blame Oracle - they made changes in the data dictionary :)

From: [email protected] [mailto:[email protected]] On Behalf Of Yong Zhang
Sent: Wednesday, May 02, 2012 8:18 PM
To: [email protected]
Subject: [toad] how to generate create user script with password in TOAD


Hi, Toad users,
I am using TOAD 10.5.1.x version. When I connect to Oracle 10g R2 database using schema browser to  generate create user script, it generate the following code:
create user username
identified by values 'somevalues'
default tablespace users;
which is very convenient for dbas to drop and recreate the users in the same or another database without having to know the passwords for a particular user.
But when I connect to 11g database, it does not generate the password values:
create user username
identified by <password>
default tablespace users;
Does anyone know where to configure the TOAD to generate the same script as Oracle 10g? Or where do I have to tweak the parameters in Oracle 11g database?
I would appreciate if someone can answer my questions or point me to some docs on the web. Please don't ask me why I have to do it this way, but I have to do it quite often.
Regards.

Yong