Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5F9189FBB2F for ; Wed, 23 May 2007 05:44:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 17995-06 for ; Wed, 23 May 2007 05:44:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 11E699FBB2B for ; Wed, 23 May 2007 05:44:38 -0300 (ADT) Received: (qmail invoked by alias); 23 May 2007 08:44:36 -0000 Received: from i3ED6C14D.versanet.de (EHLO [192.168.0.112]) [62.214.193.77] by mail.gmx.net (mp001) with SMTP; 23 May 2007 10:44:36 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX1/GWKhiY5rGjIQMRZyu2ex9MIUHzm1hkXkPXosjbq rfVblEdu0MQpcW Message-ID: <4653FEF4.3090806@gmx.net> Date: Wed, 23 May 2007 10:44:36 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8.1.2) Gecko/20070222 SeaMonkey/1.1.1 MIME-Version: 1.0 To: Scott Marlowe CC: pgsql-admin@postgresql.org Subject: Re: Can I restrict backups? References: <46523EF5.9020800@gmx.net> <46537A3A.3040709@g2switchworks.com> In-Reply-To: <46537A3A.3040709@g2switchworks.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/235 X-Sequence-Number: 25555 Scott Marlowe schrieb: > Andreas wrote: >> now this might be a bit of a silly question, but I'll give it a shot >> anyway. >> >> I'm working on a remote database for a few employees of a rather >> small startup company where at least a few will get teleworking jobs. >> They'll get a ms-access application that connects via ODBC from their >> home. >> >> They'll have limited access to the tables. Some will be just readable >> or writable. >> Obviously to work with the most intersting data they'll need reading >> an writing access. >> >> Could I somehow avoid that one of them uses pg_dump or even Access >> itself to pull all the data out and sell it to a competitor? > > You have conflicting objectives here. > You give them read access to the data, but you don't want them to read > it. That's why I wrote "silly question". > > The real issue here is a legal one. Once you let the data go from the > server to their machine, who knows what they'll do with it. Right. It's like that. They should work on projects that only contain a subset e.g. of customer addresses and subsequently on the task related objects like orders regarding the current project. The staff of my customer has quite some fluctuation since he hires mainly project based university students who can't work longer than a few weeks anyway. There's now and then one among them who knows a wee bit more than enough to test the limits of the work environment. We just want to stop them to run off with the content of our database on to of the usual pencil and coffee pot. 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. That must be a common problem for a lot of businesses so there might be concepts to counter this threat.