Home » RDBMS Server » Security » change system password (oracle 10g, windows 64 bit)
change system password [message #308843] Tue, 25 March 2008 12:31 Go to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi Experts,
i want to change the system password.could
somebody please help me on this.

Thanks,
Daniesh
Re: change system password [message #308846 is a reply to message #308843] Tue, 25 March 2008 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
connect as system and use "password" command or connect as a DBA and use "alter user system identified by new_password;".

Regards
Michel
Re: change system password [message #308850 is a reply to message #308846] Tue, 25 March 2008 13:01 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
password command mean "orapwd" command
Re: change system password [message #308852 is a reply to message #308850] Tue, 25 March 2008 13:11 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, "password" command means "password" command at SQL*Plus prompt.

Regards
Michel
Re: change system password [message #308857 is a reply to message #308852] Tue, 25 March 2008 13:17 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
i did not get it
could you please explain me this line.

connect as system and use "password" command

thanks
Re: change system password [message #308862 is a reply to message #308857] Tue, 25 March 2008 13:27 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
connect as system and use "password" command

Yes this is that.
SQL> connect system/current_password
Connected.
SQL> password

Regards
Michel
Re: change system password [message #308863 is a reply to message #308862] Tue, 25 March 2008 13:35 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
thanks a lot....
its works
thanks for your quick response.
because of you was able to solve one of the client issue.
thanks again
Re: change system password [message #309929 is a reply to message #308863] Sat, 29 March 2008 23:58 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

...because of you was able to solve one of the client issue....
And suppose Michel going on Holiday then Smile



PS: Don't mind Michel.

Previous Topic: os authentification
Next Topic: Grant restriction
Goto Forum:
  


Current Time: Mon Dec 22 21:16:32 CST 2014

Total time taken to generate the page: 0.20560 seconds