Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1728wE58655 for ; Wed, 6 Feb 2002 21:08:59 -0500 (EST) (envelope-from rudi@oasis.net.au) Received: from sun (palm.oasis.net.au [210.8.139.3]) by water.oasis.net.au (8.9.3/100.1) with SMTP id MAA09506 for ; Thu, 7 Feb 2002 12:27:51 +1000 X-Authentication-Warning: water.oasis.net.au: Host palm.oasis.net.au [210.8.139.3] claimed to be sun Message-ID: <000501c1af7d$6135c090$0c00a8c0@sun> From: "Rudi" To: References: Subject: Re: pg_shadow / pg_user Date: Thu, 7 Feb 2002 12:15:57 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200202/79 X-Sequence-Number: 6508 Hi Chris, Thanks for your reply. That's very good news. I am using Pg 7.0 at home for research and dev. It's an old box. At work we are using 7.1.3 Cheers Rudi. ----- Original Message ----- From: "Christopher Kings-Lynne" To: "Rudi" ; Sent: Thursday, February 07, 2002 12:05 PM Subject: RE: [SQL] pg_shadow / pg_user > Hi Rudi, > > In the newly-released Postgres 7.2, the passwords are now MD5 encrypted > (IIRC). I highly suggest upgrading to the new version. > > Chris > > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Rudi > Sent: Thursday, 7 February 2002 9:51 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] pg_shadow / pg_user > > > Hi friends, > > I've been learning about security using Pg lately. > Up until last night I thought system user passwords were stored safely away > in pg_user. > So far I haven't been able to get any passwords out only '*******'. > Then last night was observing each system table and found that pg_shadow > stores user passwords in clear text. > ?? > pg_shadow = clear text password > pg_user = hidden password > > I guess this means if an intruder gets an appropriate account on the box the > can view all passwords. > I had assumed that system passwords were stored hidden from all eye balls. > Sort of like apache storing http passwords in binary form in a db. > > Is this how it is ? > > If so I was thinking I like to know if someone tries or succeeds in querying > the pg_shadow table. > I thought maybe to increase the postmaster debug level so that all sql > queries are logged. > Then write a cron job to check this log and email me if it is detected that > a user is attempted or did query > the pg_shadow table. > > How does this sound ? > Am I totaly on track ? > > Thank for your time and attention > Kind regards > Rudi.