X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B180C9DC81B for ; Thu, 15 Dec 2005 18:24:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86556-10 for ; Thu, 15 Dec 2005 18:24:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtpout.eastlink.ca (smtpout.eastlink.ca [24.222.0.30]) by postgresql.org (Postfix) with ESMTP id 843B69DC820 for ; Thu, 15 Dec 2005 18:24:03 -0400 (AST) Received: from ip02.eastlink.ca ([24.222.10.10]) by mta01.eastlink.ca (Sun Java System Messaging Server 6.2-4.03 (built Sep 22 2005)) with ESMTP id <0IRK00ESH8W18QK0@mta01.eastlink.ca> for pgsql-admin@postgresql.org; Thu, 15 Dec 2005 18:24:01 -0400 (AST) Received: from blk-224-227-190.eastlink.ca (HELO [192.168.1.200]) ([24.224.227.190]) by ip02.eastlink.ca with ESMTP; Thu, 15 Dec 2005 18:23:41 -0400 Date: Thu, 15 Dec 2005 18:23:40 -0400 From: David Pratt Subject: Re: Protecting application table structures and data In-reply-to: <20051215220056.GH40699@pervasive.com> To: "Jim C. Nasby" Cc: pgsql-admin@postgresql.org Message-id: <43A1ECEC.8050807@eastlink.ca> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en X-BrightmailFiltered: true X-Brightmail-Tracker: AAAAAA== References: <43A1D9BB.2030601@eastlink.ca> <20051215220056.GH40699@pervasive.com> User-Agent: Mozilla Thunderbird 1.0.7 (Macintosh/20050923) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/159 X-Sequence-Number: 19879 Hi Jim. Many thanks for your reply. I guess this is not so great news. I am sort of at a loss as to what direction to take. I need a db connection on a couple of threads minimum in my app but also need to ensure that the information is secure. Regards David Jim C. Nasby wrote: > On Thu, Dec 15, 2005 at 05:01:47PM -0400, David Pratt wrote: > >>Hi. I am creating a desktop app and am interested in using postgres. I >>started this app with sqlite3 which is nice but not multi-threaded so I >>have run into its limitations. >> >>I want to install postgres on the users machine as part of the set up >>but want the application, if possible, to be the db admin for the >>installed pg server. Is this possible? >> >>I am hoping the application can be admin and create the tables and give >>the machine's user appropriate access without providing direct access to >>admin functions. > > > You can do this, but remember that anyone who has access to the account > postgresql is running under is going to be able to do pretty much > anything they want. And anyone with administrative access to the machine > will be able to get access to that account. > > >>Alternatively, is there a way to protect the data structures and data >>through encryption to secure the structures and data in a way that >>cannot be read by a human? Many thanks. > > > No, there isn't. In fact, I think only Oracle has that capability, > though I could be mistaken.