copying user password

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.

Regards

Quote:

---

Originally posted by dsuva
Hi,

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.

Thanks

---

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.