Обсуждение: User rights

 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?

 Thanks in advance for any help!

 Cheers,
 EBMB.

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)