Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 6E3709FB631 for ; Wed, 9 May 2007 15:09:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 76659-06 for ; Wed, 9 May 2007 15:09:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.230]) by postgresql.org (Postfix) with ESMTP id E08F69FB5F8 for ; Wed, 9 May 2007 15:09:42 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so291948wra for ; Wed, 09 May 2007 11:09:42 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BMXd8vvVfHowHxuqrKFR74AA/qbdaLwsotsGRaqjhizKANyHQFnEXeYz23y7YsYytcvi6bM+CSL46l3qVixD7f7PfoxdMnXvelJe3HifLt3uuVckumiNJcG1GsH1YQfsEQj3AZoYGW2Y+jOxPrAdNJSpTCqlBn5ezcIjNoJclHc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PT0A3c/jqjlzRcY/8uc2s1V7erbF3IjNK7SP04qMopFoMWuqhHap9D5pKelAS8CYUnMuUVDaveWlpAcuGeSuOpfGYowf2Qz5F+rNAGOgwRa7RPFV5CtCY9KMyGDrr5tAzkiFVS3vgeDejYno/gXw4WnXA8S5nwn4ZvewwQLW0qM= Received: by 10.114.254.1 with SMTP id b1mr283682wai.1178734181397; Wed, 09 May 2007 11:09:41 -0700 (PDT) Received: by 10.115.72.5 with HTTP; Wed, 9 May 2007 11:09:41 -0700 (PDT) Message-ID: <48d0cacb0705091109n6e944fd9vc1bc8a12e6596bc9@mail.gmail.com> Date: Wed, 9 May 2007 15:09:41 -0300 From: "Daniel Cristian Cruz" Subject: Re: Revoking usage of pg_catalog Cc: pgsql-admin In-Reply-To: <1178733179.7497.54.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48d0cacb0705090605i4c1c2107s2186c52468e07d46@mail.gmail.com> <1178733179.7497.54.camel@state.g2switchworks.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/63 X-Sequence-Number: 25383 2007/5/9, Scott Marlowe : > 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. Yes, I used the wrong expression. > You can grant / revoke access to anything a user should or should not be > able to access anyway. It's a web application user. I was trying to make some database magic, hardening SQL injections... But its wrong, the application must be secure. Unfortunelly I can't have a database user for each web user... Thanks... -- Daniel Cristian Cruz