Home » RDBMS Server » Server Administration » forget my user id and password what to do ?
forget my user id and password what to do ? [message #380265] Fri, 09 January 2009 22:05 Go to next message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
hi,
I forget the UID and PWD which i have given in time of installation. How can i get back them.

I have some valuable tables inside that. Can some one help me.

Ajay
Re: forget my user id and password what to do ? [message #380267 is a reply to message #380265] Fri, 09 January 2009 22:10 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
You have not read or followed Posting Guideline as stated in URL above.

>I forget the UID
What is UID?

Is your question really about Oracle RDBMS?
Re: forget my user id and password what to do ? [message #380268 is a reply to message #380267] Fri, 09 January 2009 22:19 Go to previous messageGo to next message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
no actually not RDBMS question. I have seen like Server Administration. That's why i posted here. I forget my USER ID of Oracle Database XE. Can you tell me where can i ask this question ?

ThankQ
Re: forget my user id and password what to do ? [message #380270 is a reply to message #380268] Fri, 09 January 2009 22:38 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
no actually not RDBMS question. I have seen like Server Administration.


Quote:
That's why i posted here. I forget my USER ID of Oracle Database XE. Can you tell me where can i ask this question ?


Try to connect SYS
Re: forget my user id and password what to do ? [message #380291 is a reply to message #380270] Sat, 10 January 2009 03:55 Go to previous messageGo to next message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
hi thank for reply,
what will be the default userid and password for SYS
Re: forget my user id and password what to do ? [message #380310 is a reply to message #380291] Sat, 10 January 2009 09:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
0 and change_on_install

Regards
Michel
Re: forget my user id and password what to do ? [message #380335 is a reply to message #380310] Sat, 10 January 2009 23:38 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello Mr.Michel

>>change_on_install

Quote:
I forget my USER ID of Oracle Database XE.


Above password default for Oracle Database XE ??

Babu
Re: forget my user id and password what to do ? [message #380336 is a reply to message #380265] Sun, 11 January 2009 00:09 Go to previous messageGo to next message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
solution for above problem is
connect / as sysdba

To see all users(select * from all_users)

To change the password of a user(alter user wwp identified by ' mynewpassword')

To see the user (show user;)

commit;


thankQ guys
Re: forget my user id and password what to do ? [message #380347 is a reply to message #380336] Sun, 11 January 2009 02:36 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Please posting please read the below link
http://www.orafaq.com/forum/t/88153/0/

Thanks for your feedback.

[Updated on: Sun, 11 January 2009 02:59] by Moderator

Report message to a moderator

Re: forget my user id and password what to do ? [message #380360 is a reply to message #380347] Sun, 11 January 2009 05:19 Go to previous message
msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR
Member
hello gentlebabu,

i don't understand why did you given me link. Can you tell me !!
Previous Topic: DBF files are not deleted
Next Topic: Local and Global indexes in oracle
Goto Forum:
  


Current Time: Mon Dec 05 13:09:30 CST 2016

Total time taken to generate the page: 0.10274 seconds