Re: What is the SYS password?

In article <3CC8716C.A4F46AD1_at_exesolutions.com>, Daniel says...
>
>Daniel Astillero wrote:
>
>> That's not true in all operating systems/Oracle versions. If you use Oracle
>> for Windows NT, you can choose the SYS password during the instance
>> creation, but if you use Oracle for Solaris you should change it after the
>> instance creation.
>>
>> "NorwoodThree" <norwoodthree_at_my-deja.com> escribió en el mensaje
>> news:ba03e2c.0204241303.ab11d4f_at_posting.google.com...
>> > It is whatever you set it to be.
>
>And this is not correct as a generic statement.
>
>What is absolutely true is that Oracle always install with default passwords
>and, not just on Solaris, you should change them.
>
>Daniel Morgan
>

Unfortunately this is not absolutely true. As of 9i, if you're using the DBCA to create a database, the last screen tells you that the database has been successfully created, that the passwords for SYS and SYSTEM are the defaults, and asks you to click on the Password Management button to go to a screen that allows you to change them. SCOTT is left with the default password of TIGER for regression testing (this is what the DBCA uses to test that the database has been created successfully - it attempts to log on as scott/tiger). All the other accounts are left locked and with non-default passwords. So if you unlock the sample schema accounts but don't change their passwords, you cannot log on e.g. you can't connect as OE/OE.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Apr 25 2002 - 17:23:24 CDT