Re: Forgot the password for scott

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Sun, 18 Jul 2004 22:32:21 GMT
Message-ID: <VTCKc.615$rm4.294@newsfe6-win.ntli.net>

"AK" <avinnako_at_yahoo.com> wrote in message news:c235bec4.0407181249.43b5f977_at_posting.google.com...
> Hi all,
> I am using oracle 9i on my desktop. While playing with SQL, I modified
> the password for user scott to something else and forgot it. Is there
> a way to login as DBA using SQL Plus to modify the password for scott.
> The problem is, I dont have any knowledge about other accounts on this
> server, where in I can login and modify the password. I tried logging
> in as sys/system, but I am unable to login. Can anyone suggest a way
> (syntax) to login as DBA and modify the password for scott. The system
> I am using is just a testing machine I am playing with. Thanks in
> advance.
>
> Vik!

you dont mention OS, im assuming windows.

try sqlplus "/ as sysdba" if you are the correct os user

or try sqlplus system/manager and do alter user scott identified by xxx; Received on Sun Jul 18 2004 - 17:32:21 CDT