Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id CB53C9FB30D for ; Sat, 12 May 2007 19:05:59 -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 61280-01 for ; Sat, 12 May 2007 19:05:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id E23B69FB303 for ; Sat, 12 May 2007 19:05:55 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 8F83F56495; Sat, 12 May 2007 17:05:39 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Sat, 12 May 2007 17:05:37 -0500 Date: Sat, 12 May 2007 17:05:37 -0500 From: "Jim C. Nasby" To: ebmb Cc: pgsql-admin@postgresql.org Subject: Re: User rights Message-ID: <20070512220537.GC58786@nasby.net> References: <1178739834.977825.98330@l77g2000hsb.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1178739834.977825.98330@l77g2000hsb.googlegroups.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070512:ebmb@hotmail.com::AebkxIgQTRYfPjgU:00aUm X-Hashcash: 1:20:070512:pgsql-admin@postgresql.org::uzYGrBUBLRm+UMI4:00000000000 0000000000000000000000002hOn X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/101 X-Sequence-Number: 25421 On Wed, May 09, 2007 at 12:43:55PM -0700, ebmb wrote: > Hello all, > I'm a MySQL user and trying to migrate some applications to > PostgreSQL 8.1.9. My first question is about Postgre administration... > > I would like to know if is possible to revoke users access to > commands like "\l, \du, \dn". In MySQL, limited users cannot see other > users (like root, for example) and other databases (like mysql, for > example). Is it possible in Postgre? Take a look at the setting db_user_namespace; it might help. You *might* be able to get away with revoking select on pg_database, though you'd have to do it in every database. Of course you'll want to fully understand pg_hba.conf as well. When it comes to schemas, I think you're pretty much out of luck. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)