Home » RDBMS Server » Security » how to read password ?
how to read password ? [message #8839] Mon, 29 September 2003 18:35 Go to next message
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 :)
Re: how to read password ? [message #8844 is a reply to message #8839] Tue, 30 September 2003 00:34 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: how to read password ? [message #8866 is a reply to message #8844] Tue, 30 September 2003 14:01 Go to previous message
Upperm
Messages: 95
Registered: July 2003
Member
Thans a lot MHE for your help.

Have a good working shift :)
Previous Topic: A random password generator
Next Topic: New to oracle unable to make user account
Goto Forum:
  


Current Time: Sat Aug 15 15:16:16 CDT 2020