OraFAQ Forum: Security » retrive database user password

Home » RDBMS Server » Security » retrive database user password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

retrive database user password [message #281713]

Mon, 19 November 2007 01:33

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

Report message to a moderator

Re: retrive database user password [message #281716 is a reply to message #281713]

Mon, 19 November 2007 01:37

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't.

Regards
Michel

Report message to a moderator

Re: retrive database user password [message #281717 is a reply to message #281713]

Mon, 19 November 2007 01:37

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

Report message to a moderator

Previous Topic:	encryption key management
Next Topic:	Fine grained access control

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 03 20:37:30 CDT 2026