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 25EBD3A4FEA for ; Thu, 13 Jan 2005 16:55:04 +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 68552-04 for ; Thu, 13 Jan 2005 16:54:48 +0000 (GMT) Received: from mxsf30.cluster1.charter.net (mxsf30.cluster1.charter.net [209.225.28.230]) by svr1.postgresql.org (Postfix) with ESMTP id 630A93A517C for ; Thu, 13 Jan 2005 16:54:47 +0000 (GMT) Received: from mxip14.cluster1.charter.net (mxip14a.cluster1.charter.net [209.225.28.144]) by mxsf30.cluster1.charter.net (8.12.11/8.12.11) with ESMTP id j0DGsjg2004400 for ; Thu, 13 Jan 2005 11:54:46 -0500 Received: from 24-159-243-214.jvl.wi.charter.com (HELO shiva) (24.159.243.214) by mxip14.cluster1.charter.net with ESMTP; 13 Jan 2005 11:54:46 -0500 X-Ironport-AV: i="3.88,121,1102309200"; d="scan'208"; a="716543108:sNHT87875284" Received: from quale by shiva with local (Exim 3.36 #1 (Debian)) id 1Cp8GQ-0003X0-00 for ; Thu, 13 Jan 2005 10:56:02 -0600 To: "PostgreSQL Admin" Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! References: <4001DEAF7DF9BD498B58B45051FBEA650207AB24@25exch1.vicorpower.vicr.com> From: Doug Quale Date: 13 Jan 2005 10:56:02 -0600 In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA650207AB24@25exch1.vicorpower.vicr.com> Message-ID: <87k6qh2rq5.fsf@charter.net> Lines: 17 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.032 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200501/112 X-Sequence-Number: 15971 "Goulet, Dick" writes: > to Postgres install as well. I as the DBA should be able to install, > upgrade, etc the software without access to the root account. Simply > put the fewer people who know the root password the fewer who can > destroy the system and the fewer who have to be told when the password > changes. And the fewer people who know anything, the more secure it is. This analysis is incomplete. Under this scheme, if someone cracks your account they can install trojaned or malicious executables owned by you without cracking root. The flaw is in believing that this scheme requires an intruder to crack two accounts to defeat your security. In fact, you have doubled the number of targets but left the amount of work required of the bad guys to compromise your system the same (crack one account). Put all your eggs in one basket, and WATCH THAT BASKET.