Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 741959FB4C3 for ; Mon, 21 May 2007 21:53:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 70347-03-6 for ; Mon, 21 May 2007 21:53:01 -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 DBB389FB7A7 for ; Mon, 21 May 2007 21:53:11 -0300 (ADT) Received: (qmail invoked by alias); 22 May 2007 00:53:09 -0000 Received: from i3ED6C2CB.versanet.de (EHLO [192.168.0.112]) [62.214.194.203] by mail.gmx.net (mp032) with SMTP; 22 May 2007 02:53:09 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX18HBxprGJcHA23VbIfcST1TNqM6LU3iCmfI+u/eh4 +kfgAA0e3h3Lp5 Message-ID: <46523EF5.9020800@gmx.net> Date: Tue, 22 May 2007 02:53:09 +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: pgsql-admin@postgresql.org Subject: Can I restrict backups? 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/215 X-Sequence-Number: 25535 Hi, 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?