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