Re: How to change the password of USER "INTERNAL"?

From: Moogle <martin_moogle_guardian_at_bigfoot.com>
Date: Fri, 6 Nov 1998 09:16:08 +1100
Message-ID: <71t80q$apk$1@news.mel.aone.net.au>

µR§Q! wrote in message <3641F9D9.CFD7CC5D_at_yahoo.com>...
>That's the point,
>in svrmgr
>i can connect "internal".
>but when i type "alter user internal identified by newpassword".
>It appear "ORA-01918: user 'internal' does not exist"
>why I can't change the password?
>
>victor wrote:

internal is a synonym for sys.

You shouldn't even need a password to connect internal if you are logging on from the oracle account on the server.
And you can't connect as internal from any other machine. If you are worried about people connecting as internal to your database, just restrict access to svrmgr to the oracle user.

To change the sys password...
So connect as sys or system or internal and do alter user sys identified by <password>;
then internal and sys passwords will be changed. Received on Thu Nov 05 1998 - 16:16:08 CST