copying user password

[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

[jovery]

SELECT password
FROM dba_users
WHERE user_name = 'xxx';

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

HTH

[dsuva]

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

[BV1963]

Try with no quotes:

ALTER USER yyy IDENTIFIED BY VALUES password_from above query ;

[adewri]

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

alter user username identified by values 'hashed password';

dont forget the Quotes...

[adewri]

Originally posted by BV1963
Try with no quotes:

ALTER USER yyy IDENTIFIED BY VALUES password_from above query ;

this wont work

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

[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)

[jovery]

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.

[BV1963]

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

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

User altered.

[dsuva]

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.