Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id DE1201337BB7 for ; Wed, 9 Mar 2011 20:28:58 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 95125-03 for ; Thu, 10 Mar 2011 00:28:50 +0000 (UTC) X-Greylist: delayed 00:05:32.762345 by SQLgrey-1.7.6 Received: from mailgate.iii.com (mailgate.iii.com [205.227.88.3]) by mail.postgresql.org (Postfix) with ESMTP id 272251337B82 for ; Wed, 9 Mar 2011 20:28:47 -0400 (AST) Received: from mailhub.iii.com (mailhub [10.1.2.3]) by mailgate.iii.com (8.13.6/8.13.6) with ESMTP id p2A0F0bO017031 for ; Wed, 9 Mar 2011 16:15:00 -0800 (PST) Received: from [10.1.7.210] ([10.1.7.210]) by mailhub.iii.com (8.13.6/8.13.6) with ESMTP id p2A0QeF2030749 for ; Wed, 9 Mar 2011 16:26:40 -0800 (PST) Message-ID: <4D781A21.8030109@iii.com> Date: Wed, 09 Mar 2011 16:24:01 -0800 From: Dinesh Bhandary Reply-To: dbhandary@iii.com Organization: Innovative Interfaces User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: hiding metadata information from a user Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/106 X-Sequence-Number: 36978 Hi All - Please let me know if this is possible to do in postgres. I am creating a read only user, which has limited access to db objects, primarily views. Even though this user can't query data from other db objects it can view the system catalog using pg* views and tables, thereby exposing our logical schema. Is there a way in postgres to limit access to system catalogs. I just want a pure read only user, which can do nothing but query specific views we outlined. Thanks! Dinesh