X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6AD3852EEB for ; Sat, 13 Aug 2005 11:14:36 -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 06134-09 for ; Sat, 13 Aug 2005 14:14:33 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id EEC2F52E27 for ; Sat, 13 Aug 2005 11:14:32 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j7DEEW7b012317 for ; Sat, 13 Aug 2005 14:14:32 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j7DE5B77010340 for pgsql-admin@postgresql.org; Sat, 13 Aug 2005 14:05:11 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: how to protect root access database Date: Sat, 13 Aug 2005 09:48:24 -0400 Organization: cbbrowne Computing Inc Lines: 16 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, berkeley-unix) Cancel-Lock: sha1:dDfg78BdWHBmESsTCQnfRakuyF4= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200508/171 X-Sequence-Number: 18490 > 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) The only way to be certain that system administrators cannot access patient data is to encrypt the data before storing it in the database. The book that most directly describes this approach to application design is Peter Wayner's _Translucent Databases_; see also his web site... -- (reverse (concatenate 'string "moc.liamg" "@" "enworbbc")) http://cbbrowne.com/info/ If we were meant to fly, we wouldn't keep losing our luggage.