how to decrypt the user password

[bhavanik]

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...

usename|usesysid|usecreatedb|usesuper|usecatupd |passwd|valuntil|useconfig
---------+----------+-------------+----------+-----------+-------------------------------------+--------------
 hyd     |    10 | t        | t       | t      | md5f0101924b02603efac6788bb7f096638 |

[debasisdas]

You can't do that.

Else what is the security in the database ?

[RedSon]

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.

[salimdev]

You saved me alot of Research, thanks alot.