copying user password

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

Code:

---

SELECT password
FROM dba_users
WHERE user_name = 'xxx';

ALTER USER yyy IDENTIFIED BY VALUES 'password_from above query';

---

HTH

Hi,

No it doesn't work that way'cos i had tried it out. Anyway the values in the password field in the dba_users is encrypted.

what i mean is
old user id: xyz
old password : xyz1
password in dba_users : 767B26Y8


now if i give 767B26Y8 as the password of the new user then i need to log in using 767B26Y8, but i wish to login to the new user using the old password xyz1

Try with no quotes:

ALTER USER yyy IDENTIFIED BY VALUES password_from above query ;

Are you sure you gave the command exactly as above... it works...

alter user username identified by values 'hashed password';

dont forget the Quotes...

Quote:

---

Originally posted by BV1963
Try with no quotes:

ALTER USER yyy IDENTIFIED BY VALUES password_from above query ;

---

this wont work

Code:

---

SQL> alter user amar identified by values C5D5B636B43DB0C5;
alter user amar identified by values C5D5B636B43DB0C5
                                    *
ERROR at line 1:
ORA-02153: invalid VALUES password string

---

Hi ,

This is the error i am getting.
----------------------------------------
SVRMGR> alter user ram identified by '47AE452E8CEA0C04';
alter user ram identified by '47AE452E8CEA0C04'
*
ORA-00988: missing or invalid password(s)

Quote:

---

Originally posted by dsuva
Hi ,

This is the error i am getting.
----------------------------------------
SVRMGR> alter user ram identified by '47AE452E8CEA0C04';
alter user ram identified by '47AE452E8CEA0C04'
*
ORA-00988: missing or invalid password(s)

---

Your missing the VALUES keyword.

But I was wrong anyway this won't work as you intend to change the username.

:o

You are correct: quotes are needed. It works perfectly fine for me:

1* ALTER USER TT IDENTIFIED BY VALUES 'DF305179EE5BCFED'
urc01:RMAN> /

User altered.

Hi,

yes the user is getting altered . but when i am trying to connect to the user using the old password it is failing to connect.

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.