Re: [HACKERS] Schemas: status report, call for developers - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [HACKERS] Schemas: status report, call for developers
Date
Msg-id 14093.1023552187@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Schemas: status report, call for developers  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-interfaces
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> If I remove public create access to public, can the super user or db
> owner still create tables?

Superusers can always do whatever they want.

The DB owner (assume he's not a superuser) has no special privileges
w.r.t. the public schema at the moment.  We could perhaps put in a
kluge to change this, but it would definitely be a kluge --- I don't
see any clean way to make the behavior different.

One possible approach would be for a superuser to change the ownership
of public to be the DB owner.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Schemas: status report, call for developers
Next
From: "Dave Page"
Date:
Subject: Re: database structure / generic client apps