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

Actually there was a discussion on this very subject a short while ago by the toad developer who owns that code:

http://tech.groups.yahoo.com/group/toadbeta/message/37139

John talks about the 11g changes and where he gets the values ....


--- In [email protected], Bert Scalzo <bert.scalzo@...> wrote:
>
> 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
>




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/