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
Printable View
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
HTHCode:SELECT password
FROM dba_users
WHERE user_name = 'xxx';
ALTER USER yyy IDENTIFIED BY VALUES 'password_from above query';
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...
this wont workQuote:
Originally posted by BV1963
Try with no quotes:
ALTER USER yyy IDENTIFIED BY VALUES password_from above query ;
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)
Your missing the VALUES keyword.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)
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.