Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id ECADD2E40F0 for ; Thu, 20 Dec 2007 18:04:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 22418-08 for ; Thu, 20 Dec 2007 18:04:33 -0400 (AST) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.187]) by postgresql.org (Postfix) with ESMTP id 3082A2E418F for ; Thu, 20 Dec 2007 18:04:36 -0400 (AST) Received: by mu-out-0910.google.com with SMTP id i10so100275mue.5 for ; Thu, 20 Dec 2007 14:04:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ZbaQMMMrapJ42jx/Op5xOVamL09HCQETtuAM0ORJ3S0=; b=dENhVzjkmNF/TKsW1Inavzraj3Om6wJ90rjs0w44z543guWopFxKBKGoGzZ5vU7GQYQJfnStAFgqNrNdQAAW/mZPAklyrcC3ppaE9OMWj+M6e82wvtZwOZPyv3lJDwC1V7bO5V3jTH8Jn15QYR7oZLtCGr1VsCeAPGEd6VulHIo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SidyTyHMzkLSkeLGFEvyywQo2U7aLK/oU1FvPJVAo78z4w9ilBfdHZUez/DLZDpti9ZxLd3djCgo5hoCcbkyJB33AOotkQCUvoqUVCLMUS7NWkqSFzF2V3uqsiEDvVbEnCPqu89RSnc4VucRghTDOQtW+37c2FKbPmrhZJ+Rl1k= Received: by 10.78.136.9 with SMTP id j9mr930547hud.70.1198188273841; Thu, 20 Dec 2007 14:04:33 -0800 (PST) Received: by 10.78.18.2 with HTTP; Thu, 20 Dec 2007 14:04:33 -0800 (PST) Message-ID: Date: Thu, 20 Dec 2007 17:04:33 -0500 From: "Merlin Moncure" To: "Andrew Sullivan" , pgsql-performance@postgresql.org Subject: Re: viewing source code In-Reply-To: <20071220205214.GW4924@crankycanuck.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1A6E6D554222284AB25ABE3229A92762112A33@nrtexcus702.int.asurion.com> <476A9ADF.5030101@commandprompt.com> <90bce5730712201047m4dd0fe05k6b1fccc57897326f@mail.gmail.com> <20071220114011.64a650d7@commandprompt.com> <20071220200739.GC11586@alvh.no-ip.org> <20071220205214.GW4924@crankycanuck.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/328 X-Sequence-Number: 28144 On Dec 20, 2007 3:52 PM, Andrew Sullivan wrote: > On Thu, Dec 20, 2007 at 03:35:42PM -0500, Merlin Moncure wrote: > > > > Key management is an issue but easily solved. Uber simple solution is > > to create a designated table holding the key(s) and use classic > > permissions to guard it. > > Any security expert worth the title would point and laugh at that > suggestion. If the idea is that the contents have to be encrypted to > protect them, then it is just not acceptable to have the encryption keys > online. That's the sort of "security" that inevitably causes programs to > get a reputation for ill-thought-out protections. right, right, thanks for the lecture. I am aware of various issues with key management. I said 'simple' not 'good'. there are many stronger things, like forcing the key to be passed in for each invocation, hmac, etc. etc. I am not making a proposal here and you don't have to denigrate my broad suggestion on a technical detail which is quite distracting from the real issue at hand, btw. I was just suggesting something easy to stop casual browsing. If you want to talk specifics, we can talk specifics... merlin