RE: Re: how to generate create user script with password in TOAD [1 Attachment]

That checkbox only applies to 11g.  If you have it checked, and still not getting the passwords on 11g, then I don’t think you have the privilege to select from sys.user$.

See attachment if there is any doubt of the checkbox that I’m talking about.


From: [email protected] [mailto:[email protected]] On Behalf Of Yong Zhang
Sent: Thursday, May 03, 2012 8:23 AM
To: [email protected]
Subject: Re: [toad] Re: how to generate create user script with password in TOAD


Hi John,
That is what I am using for 10g, but not working for 11g. I am using the user with dba privileges.
Thanks.

Yong


From: John Dorlon <[email protected]<mailto:[email protected]>>
To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>
Sent: Thursday, May 3, 2012 9:13 AM
Subject: RE: [toad] Re: how to generate create user script with password in TOAD


Toad 10.6 has an option to extract passwords on 11g if you have privileges.  I’m not sure offhand if the option is also on 10.5.1 but on the script dialog, go to the  “Script Options” tab, then “Users” sub-tab.  Check “If possible, include identify by values clause in 11g”.

It will be possible if you have the SELECT privilege on the sys.user$ table.

-John



From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of bscalzo
Sent: Wednesday, May 02, 2012 9:10 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] 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]<mailto:toad%40yahoogroups.com>, Bert Scalzo <bert.scalzo@...<mailto: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:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of Yong Zhang
> Sent: Wednesday, May 02, 2012 8:18 PM
> To: [email protected]<mailto:toad%40yahoogroups.com>
> 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
>