Forgot user password 1

[oaklanders]

I have a local Oracle 9i database and forgot the password for my Username. Please advise how I can reset the password? I do have the password for the sys and system logins to this local database.

 

[SantaMufasa]

Log into Oracle as a DBA (example: SYS, SYSTEM, et cetera). Then issue the command:

ALTER USER <username> IDENTIFIED BY <new password>;

Let us know how this works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[oaklanders]

Thank you.