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

From Fabien COELHO
Subject Re: BUG #1222: database owner should have implicit control
Date
Msg-id Pine.LNX.4.58.0408181456530.31684@sablons.cri.ensmp.fr
Whole thread Raw
In response to Re: BUG #1222: database owner should have implicit control  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: BUG #1222: database owner should have implicit control  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-bugs
> > > Database owner should have implicit control over public schema
> >
> > 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.
>
> was just looking at this this morning. is there anyway to change
> ownership of a schema? i couldn't find one and thought i'd ask before
> whacking on the system tables.

"ALTER SCHEMA foo OWNER TO bla" if you're a super user.

--
Fabien Coelho - coelho@cri.ensmp.fr

pgsql-bugs by date:

Previous
From: Robert Treat
Date:
Subject: Re: BUG #1222: database owner should have implicit control
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1223: RedHat Linux 8