-
Hey guys,
How will i change a user password from sqlplus prompt
typing below syntax
password <username>
thanks
-
alter user xyz identified by newpassword;
Jeff Hunter
-
in sqlplus just type password
it will ask your oldpassword
then it will ask your newpassword
your password is changed..
Radhakrishnan.M
-
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
-
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>
-
You need SQL*PLus (and database) 8.0 or higher.
-
akkerend is right, thanks !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|