Home » RDBMS Server » Security » retrive database user password
retrive database user password [message #281713] Mon, 19 November 2007 01:33 Go to next message
roni_a180
Messages: 45
Registered: October 2007
Member
hi

create user roni123 identified by roni_23

when i run following sql statement

select * from dba_users
where username ='RONI123'

then we can see this user password is "E658D81823C2AD50"

but this format is encoded, so how i can decode this password (that means i retrieve password " roni_23")
Re: retrive database user password [message #281716 is a reply to message #281713] Mon, 19 November 2007 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: retrive database user password [message #281717 is a reply to message #281713] Mon, 19 November 2007 01:37 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You cannot, isn't it nice? Oracle is secure. Passwords are hashed and the hash value is stored, not the password itself. What is it you want with this password?

MHE
Previous Topic: encryption key management
Next Topic: Fine grained access control
Goto Forum:
  


Current Time: Sun Nov 10 05:41:46 CST 2024