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 947FE9DCBB4 for ; Thu, 15 Dec 2005 17:05:51 -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 71864-09 for ; Thu, 15 Dec 2005 17:05:51 -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 CF5F69DCA82 for ; Thu, 15 Dec 2005 17:05:48 -0400 (AST) Received: from ip04.eastlink.ca ([24.222.10.20]) by mta01.eastlink.ca (Sun Java System Messaging Server 6.2-4.03 (built Sep 22 2005)) with ESMTP id <0IRK005KY59S7PQ0@mta01.eastlink.ca> for pgsql-admin@postgresql.org; Thu, 15 Dec 2005 17:05:52 -0400 (AST) Received: from blk-224-227-190.eastlink.ca (HELO [192.168.1.200]) ([24.224.227.190]) by ip04.eastlink.ca with ESMTP; Thu, 15 Dec 2005 17:01:44 -0400 Date: Thu, 15 Dec 2005 17:01:47 -0400 From: David Pratt Subject: Protecting application table structures and data To: pgsql-admin@postgresql.org Message-id: <43A1D9BB.2030601@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== 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/155 X-Sequence-Number: 19875 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. 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. Regards, David