Re: User rights - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: User rights
Date
Msg-id 20070512220537.GC58786@nasby.net
Whole thread Raw
In response to User rights  (ebmb <ebmb@hotmail.com>)
List pgsql-admin
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)

pgsql-admin by date:

Previous
From: "Linux Geeks"
Date:
Subject: Re: Moving data directory
Next
From: "Jim C. Nasby"
Date:
Subject: Re: increasing of the shared memory does not solve the problem of "OUT of shared memory"