pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: shreeseva.learning@gmail.com
To: pgsql-admin@postgresql.org
Subject: Re: Disable TRUST authentication mode
Date: Sat, 10 Mar 2012 10:38:14 -0600
Message-ID: <4F5B2F1602000025000460B7@gw.wicourts.gov> (raw)

c k  wrote:
 
> One of our customer found that few of it's employees are trying to
> change the data without having any proper rights. The simplest way
> is to get the control of the server and then change the mode of the
> authentication to trust and restart the server.
 
There's your problem right there.
 
I once had the great pleasure and honor of attending a luncheon where
Admiral Grace Hopper[1] spoke.  One of the topics she addressed was
security.  She emphasized that if someone has physical access to your
hardware, the game is over.  She asserted that if anyone in the room
gave her ten minutes alone with their computer, she could breach
security, and dared those in attendance to let her prove it.
(Nobody took her up on it.)
 
Without getting into gory details, I realize that there are
techniques which could make certain types of attack difficult even
with physical access, but there are some absolute security
deal-breakers.  If someone can log on to the OS running your database
as the root user, you had better trust that person, because they can
do pretty much anything.  Any sense that you're secure in the face of
an untrusted user with root access is purely illusionary.  What's to
stop them from creating a custom version of any software (including
PostgreSQL) which has a back-door access that lets them in?
 
It seems to me that you either need to look at providing your
software as a service, so that you retain control of the hardware, or
educate your customers on security principles.
 
-Kevin
 
[1] http://en.wikipedia.org/wiki/Grace_Hopper





view thread (12+ messages)  latest in thread

Message-ID: <4F5B2F1602000025000460B7@gw.wicourts.gov>
Permalink:  ../4F5B2F1602000025000460B7@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4F5B2F1602000025000460B7@gw.wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, shreeseva.learning@gmail.com
  Subject: Re: Disable TRUST authentication mode
  In-Reply-To: <4F5B2F1602000025000460B7@gw.wicourts.gov>
  References: <4F5B2F1602000025000460B7@gw.wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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