Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forgot user password 1

Status
Not open for further replies.

oaklanders

Technical User
Dec 9, 2007
38
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.
 
Log into Oracle as a DBA (example: SYS, SYSTEM, et cetera). Then issue the command:
Code:
ALTER USER <username> IDENTIFIED BY <new password>;
Let us know how this works for you.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top