Re: BUG #1222: database owner should have implicit control over public db schema - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1222: database owner should have implicit control over public db schema
Date
Msg-id 8677.1092769332@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1222: database owner should have implicit control over public db schema  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1222: database owner should have implicit control  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Database owner should have implicit control over public schema
> and over all objects in his database as well.

The former is debatable, the latter simply wrong.  Make the DB owner a
superuser if you want him to have absolute privileges.

There has been some discussion of causing the public schema to be owned
by the DB owner, but this has not happened yet, partly because we are
not sure of all the consequences.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1221: revoke on schema do not return error on failure
Next
From: Josh Berkus
Date:
Subject: Garbage characters for \d table?