Home » SQL & PL/SQL » SQL & PL/SQL » Forgot UserName and Password for SQL Plus..What NOW??:
Forgot UserName and Password for SQL Plus..What NOW??: [message #242717] Mon, 04 June 2007 15:59 Go to next message
Sudiptha
Messages: 2
Registered: June 2007
Junior Member
hello,
I am trying to login to SQL Plus after a loong lonng time and have forgotten my username and password..can smbdy tell me how to recover them so that I can start using SQL Plus.

[Updated on: Tue, 05 June 2007 07:56] by Moderator

Report message to a moderator

Re: Forgot UserName and Password for SQL Plus..What NOW??:(..Plzz help [message #242724 is a reply to message #242717] Mon, 04 June 2007 21:01 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
First, you have to tell us your Oracle version (4 decimals). Next, you need to tell us whether you are using a test or production database....only after that can you expect a meaningful answer

[Updated on: Mon, 04 June 2007 21:02]

Report message to a moderator

Re: Forgot UserName and Password for SQL Plus..What NOW??:(..Plzz help [message #242753 is a reply to message #242724] Tue, 05 June 2007 00:15 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What kind of username did you use? Was it a privileged user (such as SYS, for example), or an "ordinary" user (such as SCOTT)?

If it was SCOTT, connect as a privileged user (or ask your DBA to do that), search through ALL_USERS and - perhaps seeing existing "usernames" will refresh your memory.

Then do
ALTER USER your_forgotten_username IDENTIFIED BY new_password;
and that's all.
Re: Forgot UserName and Password for SQL Plus..What NOW??:(..Plzz help [message #242771 is a reply to message #242717] Tue, 05 June 2007 01:13 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition to LittleFoot's post: there is no way to know what was your password.

Regards
Michel
Previous Topic: Regarding Commit
Next Topic: Hi
Goto Forum:
  


Current Time: Fri Dec 02 16:21:42 CST 2016

Total time taken to generate the page: 0.16635 seconds