Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7710F9FBE06 for ; Wed, 9 May 2007 14:53:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 84230-03 for ; Wed, 9 May 2007 14:53:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 44D229FB9FE for ; Wed, 9 May 2007 14:53:05 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 9 May 2007 17:52:59 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 09 May 2007 12:52:59 -0500 Subject: Re: Revoking usage of pg_catalog From: Scott Marlowe To: Daniel Cristian Cruz Cc: pgsql-admin In-Reply-To: <48d0cacb0705090605i4c1c2107s2186c52468e07d46@mail.gmail.com> References: <48d0cacb0705090605i4c1c2107s2186c52468e07d46@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1178733179.7497.54.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 09 May 2007 12:52:59 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/62 X-Sequence-Number: 25382 On Wed, 2007-05-09 at 08:05, Daniel Cristian Cruz wrote: > Hi there! > > Is it possible to revoke usage of pg_catalog for a specific user? > > The reason is to secure PostgreSQL. If a user can connect to a > database, it could query pg_class, pg_attribute, pg_proc search for > specific tables and if using dblink, even database passwords... That's not security, it's obscurity. You can grant / revoke access to anything a user should or should not be able to access anyway.