X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 03B7F329D2A for ; Thu, 16 Sep 2004 15:26:35 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33239-10 for ; Thu, 16 Sep 2004 14:26:28 +0000 (GMT) Received: from hercules.tavve.com (hercules.tavve.com [66.193.76.151]) by svr1.postgresql.org (Postfix) with ESMTP id 46B54329C6B for ; Thu, 16 Sep 2004 15:26:31 +0100 (BST) Subject: securing pg_catalog To: pgsql-admin@postgresql.org X-Mailer: Lotus Notes Release 5.0.9 November 16, 2001 Message-ID: From: Mark.Miller@tavve.com Date: Thu, 16 Sep 2004 10:09:03 -0400 X-MIMETrack: Serialize by Router on hercules/Tavve(Release 5.0.9 |November 16, 2001) at 09/16/2004 10:09:06 AM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200409/148 X-Sequence-Number: 14851 I want to create a user that has read only access to the tables in a schema. I was able to configure that fine, but that user can see all of the information in the pg_catalog schema. I do not want this user to be able to see anything other than the one schema, I tried revoking rights to schema pg_catalog but the user could still see data from the pg_catalog. Is there a way to prevent access to pg_catalog schema for a specified user? TIA, Mark Mark Miller Tavve Software Co. Tavve Software Co. One Copley Parkway, Suite 480 www.tavve.com Morrisville, NC 27560 Mark.Miller@tavve.com +1 919-654-1220 fax +1 919-380-7147