How will i change a user password from sqlplus prompt
typing below syntax
alter user xyz identified by newpassword;
in sqlplus just type password
it will ask your oldpassword
then it will ask your newpassword
your password is changed..
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,.
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.
Changing password for SREDDY
Old password: *****
New password: *****
Retype new password: *****
New passwords do not match
You need SQL*PLus (and database) 8.0 or higher.
akkerend is right, thanks !
Click Here to Expand Forum to Full Width