Re: A newbie question concerning changing users in Oracle8

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0301240450.edd35_at_posting.google.com...
>
> Unfortunately this is NOT true.
> If the init.ora remote_login_password_file parameter has been set to
> EXCLUSIVE the internal password and the SYS password are by design the
> same, and running alter user sys identified will also change the
> internal password.
> If the parameter is NONE or SHARED the two passwords are NOT
> identical.
> Billie must have set the parameter to exclusive (verify this in
> sql*plus or svrmgrl: show parameter or select value from v$parameter
> where name = '<parameter name in lower case>'
> If he wants two passwords, he must change the parameter to SHARED (sys
> and internal have SYSDBA privilege) or NONE (only internal has SYSDBA
> privilege) and bounce the database.
> Uninstalling the client is NOT necessary.
>
Thank you for your help, but I have one more question (I'm really sorry for being so boring)- with what username and password should I log now into Oracle8 to be able to change the password for INTERNAL back to how it was? So far I have used the INTERNAL or SYS account to change any of the users present in Oracle8.

Thank you in advance, Billie. Received on Fri Jan 24 2003 - 14:24:09 CET