Re: Re: CONNECTIONS.INI file not picking up by new installation.

Hi John,
It works like a charm. Thank you very much for your support.  You resolved my two questions within 24 hours. I would say you are the best support of all kinds in the world. :)
 
Yong Zhang
 
 


________________________________
From: John Dorlon <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Thursday, May 3, 2012 4:31 PM
Subject: RE: [toad] Re: CONNECTIONS.INI file not picking up by new installation.


  
When you start up T11 the first time, there should have been a prompt to import settings from a prior installation.  
 
If you want to try that again, do this:
 
1)      Go to Options -> General.   Click “Open Folder.”  This will open explorer to the directory where your T11 settings are.
2)      Shut down Toad.
3)      Rename the folder from step 1.
4)      When you start up Toad again, you should get the ‘Initial settings’ dialog.    At that point, you can tell it where your 10.5 settings are and it should copy them.
 
 
 
 
From:[email protected] [mailto:[email protected]] On Behalf Of Yong Zhang
Sent: Thursday, May 03, 2012 3:01 PM
To: [email protected]
Subject: [toad] Re: CONNECTIONS.INI file not picking up by new installation.
 
  
I uninstalled 10.5.1 and installed 11.0.0.16 and it is working for me now to get the password generating creating user script. I got another question which is my CONNECTIONS.INI file is not populated on the start screen even though I copied from old user file folder to new version's user folder.
Any help would be appreciated. 
 
 
 
From:Yong Zhang <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Thursday, May 3, 2012 12:29 PM
Subject: Re: [toad] Re: how to generate create user script with password in TOAD
 
  
Thanks, John for your detailed, timely, thoroughly support on this issue. 
I really appreciate your help.
Yong
 
 
From:John Dorlon <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Thursday, May 3, 2012 12:07 PM
Subject: RE: [toad] Re: how to generate create user script with password in TOAD
 
  
OK, I took a closer look at the source code for Toad 10.5 and I believe I found the problem.
 
There is a bug in Toad 10.5.  All of this that we discussed should work in Oracle 11gR1, but due to a bug in Toad, it won’t work in 11GR2 and newer.  We didn’t check the Oracle version correctly.  This is fixed in Toad 10.6.
 
Sorry for the confusion and thank you for your patience.  
 
 
From:[email protected] [mailto:[email protected]] On Behalf Of Yong Zhang
Sent: Thursday, May 03, 2012 10:59 AM
To: [email protected]
Subject: Re: [toad] Re: how to generate create user script with password in TOAD
 
  
I did what you advised exactly and still not be able to get the password with 11g database, even though I can do with 10g and earlier versions.
Thanks.
 
From:John Dorlon <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Thursday, May 3, 2012 11:36 AM
Subject: RE: [toad] Re: how to generate create user script with password in TOAD
 
  
I just checked the source for 10.5 and that checkbox is there, so it should work.
 
After you make that grant, you’ll have to disconnect and then reconnect.  Toad only checks that privilege once in the duration of a connection.
 
And it won’t work unless that “If possible, include identify by values clause in 11g” checkbox is checked.
 
 
From:[email protected] [mailto:[email protected]] On Behalf Of Yong Zhang
Sent: Thursday, May 03, 2012 8:43 AM
To: [email protected]
Subject: Re: [toad] Re: how to generate create user script with password in TOAD
 
  
I granted select on sys.user$ to the user I am using to generate the script and still not be able to see the passoword. I may have to try with 10.6 to see if it works.
Thanks.
 
 
From:Bert Scalzo <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Thursday, May 3, 2012 9:31 AM
Subject: RE: [toad] Re: how to generate create user script with password in TOAD
 
  
The DBA role was put in place for backwards compat with Oracle 7. It does not include what current DBA’s should want or need as it was only created for backward compat and is not recommened to be used. So saying I have DBA really means nothing. You need to create your own site specific DBA type role and decide which of the hundreds of privs it should have.
 
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]>
To: "[email protected]" <[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]] On Behalf Of bscalzo
Sent: Wednesday, May 02, 2012 9:10 PM
To: [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], 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
>