Home » RDBMS Server » Security » Changing user's Password
Changing user's Password [message #25440] Thu, 24 April 2003 05:10 Go to next message
Saqib
Messages: 3
Registered: April 2002
Junior Member
I want to change user INTERNAL password. How i can?
Re: Changing user's Password [message #25444 is a reply to message #25440] Thu, 24 April 2003 07:13 Go to previous messageGo to next message
Mark
Messages: 284
Registered: July 1998
Senior Member
Try this,
alter user user_name identified by new_password;
Need sys or sysdba priv
Re: Changing user's Password [message #25446 is a reply to message #25444] Thu, 24 April 2003 07:46 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Internal is not a real Oracle user so you can't use the alter user command. When you connect as Internal, you are connected as SYS.

The connect internal password is controlled by an Oracle 'Password' file. To create a password file login at os level as the Oracle software owner and issue the command:
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=mypasswd
You should create this file when the database is shut down.

For more details have a look in your Oracle documentation (Chapter 1 of the Oracle Administrator's Guide)

HTH
Mike
Re: Changing user's Password [message #25464 is a reply to message #25446] Fri, 25 April 2003 10:18 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
The password file is only used for remote OS authentication. Often the password file is not even set up. If it is then it needs refreshing if you change the sys password.
alter user SYS identified by PASS;
Re: Changing user's Password [message #27029 is a reply to message #25446] Thu, 14 August 2003 04:50 Go to previous messageGo to next message
ajjima thinprapa
Messages: 1
Registered: August 2003
Junior Member
Do the SYS and Internal have the sane password? Befoer this tine i had changed SYS's password and next time i can not log on as sysdba.Can you help me?
Re: Changing user's Password [message #27041 is a reply to message #27029] Thu, 14 August 2003 19:36 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
Please read through all of the examples and explanations that Tom Kyte provides in the link below and see if that sheds some light on your problem:

Previous Topic: Password
Next Topic: Check whether default password has been changed by user
Goto Forum:
  


Current Time: Sat Aug 15 15:34:12 CDT 2020