Re: Problem with pg_user (somewhat urgent) - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problem with pg_user (somewhat urgent)
Date
Msg-id 4266.1066093012@sss.pgh.pa.us
Whole thread Raw
In response to Problem with pg_user (somewhat urgent)  (Oliver Fromme <olli@lurza.secnetix.de>)
List pgsql-novice
Oliver Fromme <olli@lurza.secnetix.de> writes:
> We have a PostgreSQL 7.3.4 cluster which is used by several
> customers.  Every customer has his own database.  I have
> revoked SELECT access on pg_user from the customers, because
> they should not be able to see which other customers exist
> on the cluster.

That is a bad idea (and incomplete anyway; wouldn't looking at
pg_database give the same information?)

If you really need that much separation, give each customer his own
database cluster (postmaster).

            regards, tom lane

pgsql-novice by date:

Previous
From: Systems Administrator
Date:
Subject: SQL from PLPerl
Next
From: Josh Berkus
Date:
Subject: Re: SQL from PLPerl