| Create user using another user's password [message #250204] |
Mon, 09 July 2007 02:21  |
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
|
Member |
|
|
Hi,
Anyone knows how to create a user and applying the password of another user, without the dba knowing the actual password? I am not even sure if this is ever possible.
Let me know your thoughts.
Thanks!
|
|
|
|
|
|
|
|
| Re: Create user using another user's password [message #250255 is a reply to message #250252] |
Mon, 09 July 2007 05:50  |
LaFilipina
Messages: 51
Registered: May 2007
Location: spain
|
Member |
|
|
| ebrian wrote on Mon, 09 July 2007 05:44 | Well the DBA can create a user account (user2) with another user's password (user1), but user1 needs to let user2 know what the password is.
create user user2 identified by values '<insert_user1_hashed_password_from_dba_users_table>';
|
Thanks, ebrian. But I believe this is not possible. The hash value for the password is generated using the combination of the user's name and password... therefore, if I use the same hash value from user1 to user2, in the end, the actual password will be different as the user name is different. I am not sure if I have explained myself clear but it's something to that effect.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
