By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

how to decrypt the user password

P: 4
How do I decrypt the password of a user? What is the command used for decrypting the encrypted password to normal one?

After entering into postgreSQL database and typing:
postgres=# select * from pg_shadow;

We will be getting the below listed fields..
i am a super user of the database..

password field shows :md5f0101924b02603efac6788bb7f096638 as encrypted password in Message Digest 5 algorithm...
Expand|Select|Wrap|Line Numbers
  1. usename|usesysid|usecreatedb|usesuper|usecatupd |passwd|valuntil|useconfig
  2. ---------+----------+-------------+----------+-----------+-------------------------------------+--------------
  3.  hyd     |    10 | t        | t       | t      | md5f0101924b02603efac6788bb7f096638 |
May 28 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 5K+
P: 8,127
You can't do that.

Else what is the security in the database ?
May 28 '10 #2

Expert 5K+
P: 5,000
You don't decrypt the password to check it. You can't decrypt it. It is impossible mathematically speaking.

What you do is take the password input from the user and hash it and then compare the hash against the password in your database. If the hash matches then you know they input the right password.
May 28 '10 #3

P: 1
You saved me alot of Research, thanks alot.
Apr 26 '18 #4

Post your reply

Sign in to post your reply or Sign up for a free account.