Skip site navigation (1) Skip section navigation (2)

Re: compartmentalizing users

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: jwsacksteder(at)ramprecision(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: compartmentalizing users
Date: 2004-02-27 17:23:26
Message-ID: 20040227172326.GA18900@wolff.to (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Feb 27, 2004 at 11:01:54 -0500,
  jwsacksteder(at)ramprecision(dot)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.

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-02-27 17:27:50
Subject: Re: PostgreSQL insert speed tests
Previous:From: dewins murilloDate: 2004-02-27 17:21:45
Subject: Here there is a Postgresql for Windows Sample APP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group