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. (Which,
by the way, is *more* flexible than a hack to reassign the schema
ownership to the DB owner automatically.)
regards, tom lane