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 g171iPE52526 for ; Wed, 6 Feb 2002 20:44:26 -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 MAA09116 for ; Thu, 7 Feb 2002 12:03:16 +1000 X-Authentication-Warning: water.oasis.net.au: Host palm.oasis.net.au [210.8.139.3] claimed to be sun Message-ID: <000801c1af79$f270d8f0$0c00a8c0@sun> From: "Rudi" To: Subject: pg_shadow / pg_user Date: Thu, 7 Feb 2002 11:51:23 +1000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C1AFCD.C40C2010" 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/77 X-Sequence-Number: 6507 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C1AFCD.C40C2010 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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.=20 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 st= ores user passwords in clear text. ?? pg_shadow =3D clear text password pg_user =3D hidden password I guess this means if an intruder gets an appropriate account on the box th= e 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 queryin= g the pg_shadow table. I thought maybe to increase the postmaster debug level so that all sql quer= ies 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=20 the pg_shadow table. How does this sound ? Am I totaly on track ? Thank for your time and attention Kind regards Rudi. ------=_NextPart_000_0005_01C1AFCD.C40C2010 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi friends,
 
I've been learning about securit= y using=20 Pg lately.
Up until last night I thought system user = passwords=20 were stored safely away in pg_user.
So far I haven't been able to get any pass= words out=20 only '*******'.
Then last night was observing each system = table and=20 found that pg_shadow stores user passwords in clear text.
??
pg_shadow =3D clear text password
pg_user =3D hidden password
 
I guess this means if an intruder gets an= =20 appropriate account on the box the can view all passwords.
I had assumed that system passwords were s= tored=20 hidden from all eye balls.
Sort of like apache storing http passwords= in=20 binary form in a db.
 
Is this how it is ?
 
If so I was thinking I like to know if som= eone=20 tries or succeeds in querying the pg_shadow table.
I thought maybe to increase the postmaster= debug=20 level so that all sql queries are logged.
Then write a cron job to check this log an= d email=20 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.
 
 
 
 
 
 
------=_NextPart_000_0005_01C1AFCD.C40C2010--