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 6D8D63A5D24 for ; Thu, 13 Jan 2005 20:45:37 +0000 (GMT) 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 09722-06 for ; Thu, 13 Jan 2005 20:45:30 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 4CDFA3A5D7C for ; Thu, 13 Jan 2005 20:33:05 +0000 (GMT) Received: (qmail 5502 invoked by uid 500); 13 Jan 2005 20:46:35 -0000 Date: Thu, 13 Jan 2005 14:46:35 -0600 From: Bruno Wolff III To: "Goulet, Dick" Cc: Doug Quale , PostgreSQL Admin Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! Message-ID: <20050113204635.GA5024@wolff.to> Mail-Followup-To: "Goulet, Dick" , Doug Quale , PostgreSQL Admin References: <4001DEAF7DF9BD498B58B45051FBEA650207AB73@25exch1.vicorpower.vicr.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA650207AB73@25exch1.vicorpower.vicr.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/126 X-Sequence-Number: 15985 On Thu, Jan 13, 2005 at 13:52:41 -0500, "Goulet, Dick" wrote: > Doug, > > OK, Assume that the binaries are installed under root, but a > hacker cracks PostGres, what is to stop him/her from trashing all of the > database files in the first place? Their not owned by root. Installing > malware, whether it's actual code or destroying/defacing files causes > similar if not identical problems. At least their restricted to the > postgres user. And in my book the executables are of zero value whereas > the data files, and their contained data, are of infinite value. So > under your scheme we're protecting the least valuable part of the > system at the expense of the most valuable. While often the data is the most valuable thing on the system, being able to modify the binaries can be leveraged to increase the level of access, since the binaries run with the uid of the person running them. So that if psql got trojaned, it could be used to update users paths and have people run trojan versions of such programs such as ssh.