Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A44939FB3CB for ; Wed, 23 May 2007 07:44:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 50190-09 for ; Wed, 23 May 2007 07:44:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 7E8BE9FB28C for ; Wed, 23 May 2007 07:44:38 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HqoKb-0007dd-6u for pgsql-admin@postgresql.org; Wed, 23 May 2007 06:44:37 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id D5A0A3FAF; Wed, 23 May 2007 06:44:31 -0400 (EDT) Date: Wed, 23 May 2007 06:44:31 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Can I restrict backups? Message-ID: <20070523104431.GG25829@phlogiston.dyndns.org> References: <46523EF5.9020800@gmx.net> <46537A3A.3040709@g2switchworks.com> <4653FEF4.3090806@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4653FEF4.3090806@gmx.net> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/239 X-Sequence-Number: 25559 On Wed, May 23, 2007 at 10:44:36AM +0200, Andreas wrote: > The problem - not only - of my customer is that he primarily has to > trust strange people enough to grant them access to the very base of his > business and this base could be carried away on an USB stick or piped > out via email or whatever. > Legal repercussions against the individual when the worst case happened > are no actual solution, I fear. The only actually useful advice one can give in that case is, "Don't do that." If the business is worth having, it's surely worth protecting by hiring people you can trust. But you could restrict the subset of the data they can see using VIEWs. A -- Andrew Sullivan | ajs@crankycanuck.ca The whole tendency of modern prose is away from concreteness. --George Orwell