pg_shadow passwd decrypt

Started by Hemapriyaabout 21 years ago3 messagesgeneral

Jump to latest

Hemapriya

priyam_1121@yahoo.com

about 21 years ago

Hi,

Does postgres support any system functions that
decode/decrypt the user passwords stored in pg_shadow
system catalog.

Is there a way to retrieve the passwords, if
forgotten.

Thanks in Advance.

Priya

__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/

Bruce Momjian

bruce@momjian.us

about 21 years ago

In reply to: Hemapriya (#1)

Re: pg_shadow passwd decrypt

Hemapriya wrote:

Hi,

Does postgres support any system functions that
decode/decrypt the user passwords stored in pg_shadow
system catalog.

Is there a way to retrieve the passwords, if
forgotten.

No. They are MD5 and are designed to be unencryptable.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Arcane_Rhino

arcane_rhino@yahoo.com

about 21 years ago

In reply to: Bruce Momjian (#2)

Fwd: Re: [GENERAL] pg_shadow passwd decrypt

One can, however, simply delete the forgotten password
and create another for temporary usage until the user
in question can create a new one. (At least one could
in 7.4, I have not tried it in 8.0.)

Jeff

--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:

Show quoted text

From: Bruce Momjian <pgman@candle.pha.pa.us>
Subject: Re: [GENERAL] [ADMIN] pg_shadow passwd
decrypt
To: Hemapriya <priyam_1121@yahoo.com>
Date: Wed, 2 Mar 2005 11:16:19 -0500 (EST)
CC: pgsql-admin@postgresql.org,
pgsql-general@postgresql.org

Hemapriya wrote:

Hi,

Does postgres support any system functions that
decode/decrypt the user passwords stored in

pg_shadow

system catalog.

Is there a way to retrieve the passwords, if
forgotten.

No. They are MD5 and are designed to be
unencryptable.
-- 
Bruce Momjian                        | 
http://candle.pha.pa.us
pgman@candle.pha.pa.us               |  (610)
359-1001
+  If your life is a hard drive,     |  13 Roberts
Road
+  Christ can be your backup.        |  Newtown
Square, Pennsylvania 19073
---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose
an index scan if your
joining column's datatypes do not match

Import Notes

Resolved by subject fallback