From: Scott Marlowe <smarlowe@g2switchworks.com>
To: wisan watcharinporn <maccran@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: how to protect root access database
Date: Mon, 22 Aug 2005 14:49:00 -0500
Message-ID: <1124740140.28179.9.camel@state.g2switchworks.com> (raw)
In-Reply-To: <BAY18-F5AA154D4379168D8CC4D2BEBF0@phx.gbl>
References: <BAY18-F5AA154D4379168D8CC4D2BEBF0@phx.gbl>
On Fri, 2005-08-12 at 22:37, wisan watcharinporn wrote:
> i have database with critical data (such patient information)
> how can i protect my database from root access
> because this host in company can access with root from many person
> (person who manage some service application on host but must not access this
> patient information)
Ever seen the TShirt "Got root?" If you're root, you're god, pretty
much, and get whatever you want.
If the data is encrypted before being passed to that server, then you've
got some protection, but at a higher processing cost.
Generally, when I've worked on database machines, there is one system
admin who can log into the machine, and one dba who has the ability to
sudo to the postgresql superuser and keep the db happy. That limits the
number of people to two. If your DB can keep a unix box happy, then let
him own the whole thing and you've got minimum exposure.
Expecting to limit roots access once he's on the box is the exact
backwards way to handle this. The way to restrict access is to restrict
the people who can access the box and the levels of their accounts.
If you're in an environment where more than 2 or 3 three people need to
know the root password, your environment is messed up.
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: smarlowe@g2switchworks.com, maccran@hotmail.com
Subject: Re: how to protect root access database
In-Reply-To: <1124740140.28179.9.camel@state.g2switchworks.com>
References: <BAY18-F5AA154D4379168D8CC4D2BEBF0@phx.gbl> <1124740140.28179.9.camel@state.g2switchworks.com>
* 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