Skip site navigation (1) Skip section navigation (2)

Re: BUG #1222: database owner should have implicit control over public db schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "radim kolar" <hsn(at)netmag(dot)cz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1222: database owner should have implicit control over public db schema
Date: 2004-08-17 19:02:12
Message-ID: 8677.1092769332@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Stefanos HarhalakisDate: 2004-08-17 19:11:26
Subject: pgsql 8.0.0b1 - openssl detection
Previous:From: Tom LaneDate: 2004-08-17 18:59:39
Subject: Re: BUG #1221: revoke on schema do not return error on failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group