pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: ebmb <ebmb@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: User rights
Date: Sat, 12 May 2007 17:05:37 -0500
Message-ID: <20070512220537.GC58786@nasby.net> (raw)
In-Reply-To: <1178739834.977825.98330@l77g2000hsb.googlegroups.com>
References: <1178739834.977825.98330@l77g2000hsb.googlegroups.com>

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)



view thread (8+ messages)

Message-ID: <20070512220537.GC58786@nasby.net>
Permalink:  ../20070512220537.GC58786@nasby.net/
Also on:    postgresql.org/message-id/20070512220537.GC58786@nasby.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: decibel@decibel.org, ebmb@hotmail.com
  Subject: Re: User rights
  In-Reply-To: <20070512220537.GC58786@nasby.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox