Re: What is the SYS password?

Pete Sharman wrote:

> 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;

Are you saying that as of 9i the CREATE DATABASE command is been removed?

Daniel Morgan Received on Thu Apr 25 2002 - 18:34:45 CDT