Re: Internal password

Hi !
Indeed, I can Alter the Internal password with "alter user sys identified by toto"
Safely, I know the Internal password with which I am connected !

But but me and other french "newsgoupers" have problems ! So :

 login sys/titi is ok

I am connecting with internal/titi

Now I modify the password :

    SQL>password

     Modification of SYS password
      Previous pass: titi
        new : toto

    I log off
    then login with sys/toto => ok

    I log off
    then login with internal/toto => insufficient privileges

    I log off
then login internal/titi => ok !!!

So Internal is still with the previous pass !!!!

More...I have an other problem :
When I create my database, Oracle ask me for Internal passe. I give it : "toto"
At the end of the creation of the database, Oracle tells me the following pass :

    Internal : ****
    SYS : change_on_install
    SYSTEM : manager

but here, Internal <> SYS !!!!
I can't login with Internal/change_on_install !!! I can't login with SYS/toto !!!!!!!!!!

What's the problem ??????

Thanks

Laurent

"Howard J. Rogers" <dba_at_hjrdba.com> a écrit dans le message de news: a6o97g$rc1$1_at_lust.ihug.co.nz...
> alter user sys identified by whatever.
>
> Internal is just a keyword that means 'log me on as SYS with sysdba
> privileges'. Therefore, by altering SYS's password, you modify
internal's.
>
> However, the 'internal" keyword is deprecated from Oracle 8.0 onwards, and
> disappears completely in 9i, so the correct form of log on is 'connect
> sys/whatever as sysdba'.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Laurent Boutet" <laurent.boutet1_at_libertysurf.fr> wrote in message
> news:a6n9e6$mda$1_at_reader1.imaginet.fr...
> > Hi !
> >
> > How do I change the Internal password ?????
> >
> > Thanks in advance
> > Laurent
> >
> >
>
>
Received on Thu Mar 14 2002 - 03:05:03 CST