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.
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 Mike Lewis 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
- Thread starter oaklanders
- Start date
- Status
-
1
- #2
SantaMufasa
Technical User
Log into Oracle as a DBA (example: SYS, SYSTEM, et cetera). Then issue the command:
Let us know how this works for you.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
Code:
ALTER USER <username> IDENTIFIED BY <new password>;(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question