OraFAQ Forum: Security » Changing user's Password

Home » RDBMS Server » Security » Changing user's Password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing user's Password [message #25440]

Thu, 24 April 2003 05:10

Saqib
Messages: 3
Registered: April 2002

Junior Member

I want to change user INTERNAL password. How i can?

Report message to a moderator

Re: Changing user's Password [message #25444 is a reply to message #25440]

Thu, 24 April 2003 07:13

Mark
Messages: 284
Registered: July 1998

Senior Member

Try this,
alter user user_name identified by new_password;
Need sys or sysdba priv

Report message to a moderator

Re: Changing user's Password [message #25446 is a reply to message #25444]

Thu, 24 April 2003 07:46

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

Report message to a moderator

Re: Changing user's Password [message #25464 is a reply to message #25446]

Fri, 25 April 2003 10:18

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;

Report message to a moderator

Re: Changing user's Password [message #27029 is a reply to message #25446]

Thu, 14 August 2003 04:50

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?

Report message to a moderator

Re: Changing user's Password [message #27041 is a reply to message #27029]

Thu, 14 August 2003 19:36

Barbara Boehmer
Messages: 9088
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:

problem to connect as sysdba

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 19:53:25 CDT 2024