pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_shadow passwd decrypt
3+ messages / 3 participants
[nested] [flat]
* pg_shadow passwd decrypt
@ 2005-03-02 16:06 Hemapriya <priyam_1121@yahoo.com>
2005-03-02 16:16 ` Re: pg_shadow passwd decrypt Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Hemapriya @ 2005-03-02 16:06 UTC (permalink / raw)
To: pgsql-admin; pgsql-general@postgresql.org
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_shadow passwd decrypt
2005-03-02 16:06 pg_shadow passwd decrypt Hemapriya <priyam_1121@yahoo.com>
@ 2005-03-02 16:16 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2005-03-02 16:16 UTC (permalink / raw)
To: Hemapriya <priyam_1121@yahoo.com>; +Cc: pgsql-admin; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Fwd: Re: [GENERAL] pg_shadow passwd decrypt
@ 2005-03-02 20:10 Arcane_Rhino <arcane_rhino@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Arcane_Rhino @ 2005-03-02 20:10 UTC (permalink / raw)
To: pgsql-admin; pgsql-general@postgresql.org
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:
> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-03-02 20:10 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-02 16:06 pg_shadow passwd decrypt Hemapriya <priyam_1121@yahoo.com>
2005-03-02 16:16 ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-03-02 20:10 Fwd: Re: [GENERAL] pg_shadow passwd decrypt Arcane_Rhino <arcane_rhino@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox