It will alter the values but you won't be able to connect with the old password unless the username is the same.
Obviously the username is used to encrpyt the password.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Re: copying user password
Changing a user name? You have a lot more issues to deal with than just changing the name and keeping the same password. Roles, privileges, object ownership, and so on.
Originally posted by dsuva
we currently have a list of database users. we need to recreate the same user with a different username because of a different naming convention which we need to follow. How do i create the new user with the old password.
Click Here to Expand Forum to Full Width