Andrew - Supernews <[EMAIL PROTECTED]> writes:
> On 2005-09-01, Tom Lane <[EMAIL PROTECTED]> wrote:
>> There is some merit in the thought that the DB owner should be able to
>> grant and revoke access on the public schema, but that no longer
>> requires ownership, only membership in an appropriate role.
> How would that work without superuser intervention, given that the
> ownership of public would be the same in all databases regardless of
> who created them?
Change the ownership of public in template1 to be a "dbadmin" group.
Grant membership in "dbadmin" to all the DB owners. End of problem.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
