Re: TODO item: set proper permissions on non-system schemas - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: TODO item: set proper permissions on non-system schemas
Date
Msg-id slrndhecoo.1vfu.andrew+nonews@trinity.supernews.net
Whole thread Raw
In response to TODO item: set proper permissions on non-system schemas  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-hackers
On 2005-09-01, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andrew - Supernews <andrew+nonews@supernews.com> writes:
>> On 2005-09-01, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> Change the ownership of public in template1 to be a "dbadmin" group.
>>> Grant membership in "dbadmin" to all the DB owners.  End of problem.
>
>> Only if all db owners are equivalent.
>
> If you don't want some of them to have control over their public
> schemas, you don't grant them membership in this group.

What if you don't want them to have control over _each other's_ public
schemas?

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services


pgsql-hackers by date:

Previous
From: Matt Miller
Date:
Subject: PG_PAGE_LAYOUT_VERSION - Should be Documented as 3?
Next
From: Andrew Dunstan
Date:
Subject: Re: TODO item: set proper permissions on non-system schemas