Re: Multiple Servers - Mailing list pgsql-admin

From C. Bensend
Subject Re: Multiple Servers
Date
Msg-id Pine.BSO.4.33L2.0108202126420.18291-100000@fusion.bennyvision.com
Whole thread Raw
In response to Re: Multiple Servers  (Chris Cameron <chris@upnix.com>)
Responses Re: Multiple Servers
List pgsql-admin
On Mon, 20 Aug 2001, Chris Cameron wrote:

> Actually, that's my exact same problem AND setup.
>
> Making a user that can create databases, but not users is a decent idea.
> That's what I'll be doing for my more trusted users. However, beyond that
> it looks like the only choice is to run multipule postmasters.

Well, kinda...  I don't want my users to be able to create
databases.  I only want them to create tables, modify
tables, etc.

_I_, as the hosting provider, will create the database for
them.  And I will add their user.  From then on, said user
should only be able to create/modify/drop tables, etc, WITHIN
their own database.

Is running multiple postmasters the _only_ way to achieve this?
If so, this is not so good.  :/

Benny


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You see, we're leveraging the synergies of our existing open source
solution, without reliance on a single vendor.
Or in english: We use samba cause NT sucks ass.
                                                       --greg@rage.net



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple Servers
Next
From: Chris Cameron
Date:
Subject: Re: Multiple Servers