Password change

[tompk]

Hey guys,

How will i change a user password from sqlplus prompt
typing below syntax

password <username>

thanks

[marist89]

alter user xyz identified by newpassword;

[omegamark]

in sqlplus just type password
it will ask your oldpassword
then it will ask your newpassword

your password is changed..

[tompk]

I am not able to change password typing password in sql prompt.

Do you know the reason ?

I am able to change using Alter user syntax,.

thanks

[sreddy]

what version of sqlplus you are using ?

I tried just before on SQL*Plus 8, it should work. Idin't want to change mine. thats why it was showing error message.

<font face=courier>
SQL> password
Changing password for SREDDY
Old password: *****
New password: *****
Retype new password: *****
New passwords do not match
Password unchanged
</font>

[akkerend]

You need SQL*PLus (and database) 8.0 or higher.

[tompk]

akkerend is right, thanks !