OraFAQ Forum: Security » how to read password ?

Home » RDBMS Server » Security » how to read password ?

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

how to read password ? [message #8839]

Mon, 29 September 2003 18:35

Upperm
Messages: 95
Registered: July 2003

Member

Hello folks,
I've created a database.
I've created some users, each with a password.
When I type this querry :
"SELECT USERNAME,PASSWORD FROM DBA_USERS"
I receive a password that I have never given !
What should I do to receive a correct password ?

Thanks a lot :)

Report message to a moderator

Re: how to read password ? [message #8844 is a reply to message #8839]

Tue, 30 September 2003 00:34

Maaher
Messages: 7065
Registered: December 2001

Senior Member

The passwords are stored in hash, to avoid greedy eyes from seeing them. There's no way in which you can recuperate the password, because it is a one way encryption and Oracle compares the hash of the password you give with the one stored. Just basic security... . If you want to connect as a user of whom you don't know the password without changing it, look at this script of Tom Kyte.

MHE

Report message to a moderator

Re: how to read password ? [message #8866 is a reply to message #8844]

Tue, 30 September 2003 14:01

Upperm
Messages: 95
Registered: July 2003

Member

Thans a lot MHE for your help.

Have a good working shift :)

Report message to a moderator

Previous Topic:	A random password generator
Next Topic:	New to oracle unable to make user account

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 01 22:25:27 CST 2026