Re: compartmentalizing users - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: compartmentalizing users
Date
Msg-id 20040227172326.GA18900@wolff.to
Whole thread Raw
In response to compartmentalizing users  (jwsacksteder@ramprecision.com)
Responses Re: compartmentalizing users
List pgsql-general
On Fri, Feb 27, 2004 at 11:01:54 -0500,
  jwsacksteder@ramprecision.com wrote:
> Is there a way to segregate users by database or schema so that in a hosting
> situation you could keep different customers apart? Otherwise, the
> unpleasant alternative is to run separate instances of Postgres.

Yes, but the separation isn't total. One solution would be to have a DB
per user. However all users will still be able to see the shared
system tables. This will allow them to see schema (DDL definitions)
of other users. Though they won't be able to get at other user's
data.

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: correlated delete with 'in' and 'left outer join'
Next
From: "dewins murillo"
Date:
Subject: Here there is a Postgresql for Windows Sample APP