X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7ADA2D76C0 for ; Mon, 22 Aug 2005 16:49:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47108-05 for ; Mon, 22 Aug 2005 19:48:59 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 2A446D7691 for ; Mon, 22 Aug 2005 16:48:58 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 22 Aug 2005 14:49:00 -0500 Subject: Re: how to protect root access database From: Scott Marlowe To: wisan watcharinporn Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1124740140.28179.9.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 22 Aug 2005 14:49:00 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 required=5 tests=[AWL=0.004] X-Spam-Level: X-Archive-Number: 200508/274 X-Sequence-Number: 18593 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.