Re: Multiple Servers - Mailing list pgsql-admin

From Tom Lane
Subject Re: Multiple Servers
Date
Msg-id 27213.998361211@sss.pgh.pa.us
Whole thread Raw
In response to Re: Multiple Servers  ("C. Bensend" <benny@bennyvision.com>)
Responses Re: Multiple Servers  (Chris Cameron <chris@upnix.com>)
Re: Multiple Servers  ("C. Bensend" <benny@bennyvision.com>)
List pgsql-admin
"C. Bensend" <benny@bennyvision.com> writes:
> I have since revised my ideas of how my databases should
> be set up, ie:
>     * Users need to have superuser access to their OWN
>       databases
>     * Users should not have the ability to create users
>       or databases
>     * Users _need_ to be able to create tables, modify
>       tables, drop tables, etc

Do they really need to be superusers, as opposed to just database
owners?  ISTM that what you are really after is simply that each
user is the owner of his own database, and has no other special
privileges.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple Servers
Next
From: "C. Bensend"
Date:
Subject: Re: Multiple Servers